Skip to main content

  I created a new order report with a crystal layout. When I try to preview it then it gives an error.  

 

 

 

Hi @ruwanrohitha,

 

This does not look like a core view in the application. Please try garanting select privileges on this view to both IFSSYS and IFSPRINT users and try to order the report again.

GRANT SELECT ON <view name> TO IFSSYS;
GRANT SELECT ON <view name> TO IFSPRINT;

 

Hope this helps!

 

 

Hi @ruwanrohitha ,

Also, check whether you can preview the report in SAP crystal reports designer when you connect to the correct database. 

The report works fine in crystal report designer

Hi @ruwanrohitha,

 

This does not look like a core view in the application. Please try garanting select privileges on this view to both IFSSYS and IFSPRINT users and try to order the report again.

GRANT SELECT ON <view name> TO IFSSYS;
GRANT SELECT ON <view name> TO IFSPRINT;

 

Hope this helps!

 

 

The report works fine now,

Thanks a lot

Hi @ruwanrohitha,

 

This does not look like a core view in the application. Please try garanting select privileges on this view to both IFSSYS and IFSPRINT users and try to order the report again.

GRANT SELECT ON <view name> TO IFSSYS;
GRANT SELECT ON <view name> TO IFSPRINT;

 

Hope this helps!

 

 

a few months ago, I created an order report and run them without granting access to IFSYS and IFSPRINT. But now I want to do access grants to reports. what is the reason for it. is it due to any system changes?

Terms & ConditionsCookie settings