A newly created Order Report using a Crystal layout throws an error when previewed, and the underlying view referenced doesn't look like a core application view — what's a common fix?

All FAQ questions / Reporting and analytics

Answer

Grant SELECT privileges on that specific view to both the IFSSYS and IFSPRINT database users — GRANT SELECT ON <view_name> TO IFSSYS; and GRANT SELECT ON <view_name> TO IFSPRINT; — then try ordering/previewing the report again. Custom or non-core views used in a report layout need both of these grants for the report engine and the printing service to actually query them, which core application views already carry by default.

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