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!
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.
Darren
I have had this issue before and the attached file helped in resolving the issue.
John
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:
If you are unable to add \ from your crystal report designer check the known limitation section for a manual fix for your designer.
Regards,
*Admin Update: Replaced wit links with docs links (April 2020)
Thank you all for your help. Granting access to the crystal_web_util_api to IFSSYS user has resolved the issue.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.