Skip to main content
Solved

crystal report preview error

  • August 24, 2021
  • 5 replies
  • 403 views

Forum|alt.badge.img+3

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

 

 

 

Best answer by Charith Epitawatta

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!

 

 

This topic has been closed for replies.

5 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

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!

 

 


Minoshini Fonseka
Superhero (Employee)
Forum|alt.badge.img+19

Hi @ruwanrohitha ,

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


Forum|alt.badge.img+3
  • Author
  • Do Gooder
  • August 25, 2021

The report works fine in crystal report designer


Forum|alt.badge.img+3
  • Author
  • Do Gooder
  • August 25, 2021

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


Forum|alt.badge.img+3
  • Author
  • Do Gooder
  • August 25, 2021

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?