Skip to main content

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.

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.

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)

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