Solved

crystal report preview error

  • 24 August 2021
  • 5 replies
  • 292 views
R
Rank
Badge +3

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

 

 

 

icon

Best answer by Charith Epitawatta 24 August 2021, 22:40

View original
This topic has been closed for comments

5 replies

Charith Epitawatta
Rank
Userlevel 7
Badge +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!

 

 

Charith - https://charith.xyz
Minoshini Fonseka
Rank
Userlevel 7
Badge +19

Hi @ruwanrohitha ,

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

/Mino
R
Rank
Badge +3

The report works fine in crystal report designer

R
Rank
Badge +3

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

R
Rank
Badge +3

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