Skip to main content
Solved

Package procedure field to Crystal Report Quick report

  • Mar 26, 2021 1:41 PM UTC
  • 3 replies
  • 262 views
Do Gooder (Customer)
Forum|alt.badge.img+1
  • GTGes
  • Do Gooder (Customer)

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.

Best answer by EntNadeeL

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)

View original
    This topic has been closed for replies.

    3 replies

    dhlelk
    Superhero
    Forum|alt.badge.img+15
    • dhlelk
    • Superhero
    • Mar 26, 2021 5:02 PM UTC

    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
    Hero (Partner)
    Forum|alt.badge.img+10
    • EntNadeeL
    • Hero (Partner)
    • Answer
    • Mar 29, 2021 7:35 AM UTC

    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/
    Do Gooder (Customer)
    Forum|alt.badge.img+1
    • GTGes
    • Author
    • Do Gooder (Customer)
    • Mar 29, 2021 2:14 PM UTC

    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 & ConditionsAccessibility statement