I created a new order report with a crystal layout. When I try to preview it then it gives an error.
Solved
crystal report preview error
+3Best answer by Charith Epitawatta
Hi
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 comments
+31Hi
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
+19Hi
Also, check whether you can preview the report in SAP crystal reports designer when you connect to the correct database.
+3Charith Epitawatta wrote:
Hi
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
+3Charith Epitawatta wrote:
Hi
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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.