Solved

New Crystal Quick Report

  • 20 March 2020
  • 4 replies
  • 745 views
D
Rank
Userlevel 3
Badge +7

I have created a new Crystal report to be run in the client as a quick report in Apps 10.  I have followed the IFS Crystal guidelines and used the stored procedure CR_WEB_INIT.

I have made sure it can be run in Crystal as IFSAPP and IFSPRINT and have granted permissions to be able to run the quick report.

The issue is that when I run it in the client I am asked to provide sign on information for IFSAPP.

Any ideas on how to resolve this issue would be appreciated.  Thanks!

icon

Best answer by darren j turner 23 March 2020, 12:12

View original

4 replies

Rusiru Dharmadasa
Rank
Userlevel 7
Badge +19

Quick reports are executed as IFSSYS user. So try using IFSSYS in Crystal. Also double check CR_WEB_INIT is properly set as explained in the docs.

Rusiru
R
Rank
Userlevel 7
Badge +18

Darren

I have had this issue before and the  attached file helped in resolving the issue.

John

1 Attachment
ChanakaAmarasekara
Rank
Userlevel 7
Badge +15

Hi,

In order to have automatic login you need to give a alias to the views used in the main and sub-reports.

\ or _A for schema owner views

\\ or _Ifor IAL owner views

You will be prompt to provide login information without the above alias.

Example on how to create a Crystal QR:

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/010_example/default.htm

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/020_cr_wb_init/default.htm

 

If you are unable to add \ from your crystal report designer check the known limitation section for a manual fix for your designer.

https://docs.ifs.com/techdocs/Foundation1/050_development/026_br_and_a/005_adhoc_reporting/080_dev_crep/005_cr_as_quickreport/default.htm

 

Regards,

 

 

*Admin Update: Replaced wit links with docs links (April 2020)

- Chanaka Am -
D
Rank
Userlevel 3
Badge +7

Thank you all for your help. Granting access to the crystal_web_util_api to IFSSYS user has resolved the issue.

:relaxed:

Reply


Terms & ConditionsCookie settings