Skip to main content
Solved

crystal report preview error

  • Aug 24, 2021 6:04 PM UTC
  • 5 replies
  • 449 views
Sidekick
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!

 

 

View original
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!

 

 

Charith - https://charith.pro
    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. 

    /Mino
      Sidekick
      Forum|alt.badge.img+3
      • ruwanrohitha
      • Author
      • Sidekick
      • Aug 25, 2021 3:37 AM UTC

      The report works fine in crystal report designer

      Sidekick
      Forum|alt.badge.img+3
      • ruwanrohitha
      • Author
      • Sidekick
      • Aug 25, 2021 3:42 AM UTC

      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

      Sidekick
      Forum|alt.badge.img+3
      • ruwanrohitha
      • Author
      • Sidekick
      • Aug 25, 2021 4:03 AM UTC

      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 & ConditionsAccessibility statement