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

Hope this resolves your issue.

Cheers!

This is likely due to the way you have defined the views in the Crystal Report layout.

https://docs.ifs.com/techdocs/default.htm?openpage=https://docs.ifs.com/techdocs/Foundation1/050_development/default.htm

Add \ or \\ to the end of alias for IFS Applications data sources
The alias for report databases that are connected to a view owned by the APPOWNER user should be changed to have a backslash (\) at the end of the alias name. Report databases connected to views owned by the IALOWNER user should have two backslashes (\\) at the end of their alias name.

This alias-naming convention is important because it is used by Foundation1 to identify which report databases can be automatically logged on.

Example alias names: "Fnd_User\", "Sales_Statistics\\"

Hi @kimsiang,

Please follow the below documentation. This will guide you to  resolve the issue.

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 

Thank you.

Hi,

You have to fix this in design time of the layout.

In the layout for every view you use you need to add an alias as given below.

\ or _A  for IFS schema owner views (e.g. ifsapp)

\\ or _I for IAL owner views (e.g. ifsinfo)

By adding the alias the IFS Crystal Report integration framework will skip the prompting of the login info and set it internally by the framework code. The server and the database will be the current logged in runtime database and the user will be the client logged in user.

This is also documented in the Development guide:

Check step 5:

ttps://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

Check “Considerations and design guide lines” and “Known limitations” sections to fix any issue that you might get when trying to add the alias \ from the CR designer

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

Regards,

If you are using IFS EE, Aurena or IFS Web Client then you need to do that above as well. Yet, this will enable row based security when running the report. The prompt will not stop. For that you need to add the alias.

Hi Guys, thanks for the guidance. My problem solved after added _A to the view and table.