+1Hello,
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.
Best answer by EntNadeeL
Hi
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)
+15Hi
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.
+10Hi
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)
+1Hello,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
