Solved

Package procedure field to Crystal Report Quick report

  • 26 March 2021
  • 3 replies
  • 180 views
G
Rank
Badge +1
  • GTGes
  • Do Gooder (Customer)
  • 1 reply

Hello,

I am wondering what is the procedure for adding package procedures to Crystal Report Quick Reports in IFS? For example I would like to add  Delivery_Route_API.Get_Description(ROUTE_ID).

Is there any way to add this without joining the Delivery Route table or it’s just not supported?

 

Thank you.

icon

Best answer by EntNadeeL 29 March 2021, 09:35

View original
This topic has been closed for comments

3 replies

dhlelk
Rank
Userlevel 6
Badge +15

Hi @GTGes,

 

As per the documentation,

PLSQL Package procedures are not supported.
PLSQL Package procedures are not supported by the IFS reporting framework. Instead one can use Oracle Stored Procedures. If an Oracle stored procedure is used in the report, the necessary permission should be granted.

 

Cheers !
Dhananjaya.

https://www.linkedin.com/in/kludl/
EntNadeeL
Rank
Userlevel 5
Badge +9

Hi @GTGes ,

Try adding PLSQL procedures in a Crystal Report (Using SQL Expression Fields)as below. This should work. 

<ifsowner>.Delivery_Route_API.Get_Description(ROUTE_ID)

ifsapp.Delivery_Route_API.Get_Description(ROUTE_ID)

Nadeesha Liyanage - https://www.linkedin.com/in/nadeeshaliyanage/
G
Rank
Badge +1

Hello,

I am wondering what is the procedure for adding package procedures to Crystal Report Quick Reports in IFS? For example I would like to add  Delivery_Route_API.Get_Description(ROUTE_ID).

Is there any way to add this without joining the Delivery Route table or it’s just not supported?

 

Thank you.

That worked.

Thank you @EntNadeeL

Terms & ConditionsCookie settings