Is it possible to call a custom PL/SQL package function (like `Delivery_Route_API.Get_Description(ROUTE_ID)`) directly inside a Crystal Report Quick Report, without joining the underlying table the function itself looks up?

All FAQ questions / Reporting and analytics

Answer

Yes — reference the function directly, schema-qualified, inside a Crystal Report SQL Expression Field: <ifsowner>.Delivery_Route_API.Get_Description(ROUTE_ID) (for example, ifsapp.Delivery_Route_API.Get_Description(ROUTE_ID)). This calls the function directly from the SQL Expression Field and doesn't require joining the Delivery Route table (or whatever table the function operates on) into the report at all, since the function performs its own lookup internally.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions