Monday 6 January 2014

Running Crystal Reports Database Login Needed in BI4 for Viewing

When trying to view Crystal Reports in Business Objects BI4 a database Login box pops up when viewing a Crystal Report via SSO Single Sign on.

OpenDocument parameters can be used to pass in details to a Crystal Report so that it can be viewed directly from a URL but you may also get a login box for the underlying database.

This database connection cannot be set within the Crystal Report and it isn't advisable or helpful for users to have to enter database credentials every time they want to run a report.

The answer is that an option needs to be set via Business Objects CMC Central Management Console. Right click on the Crystal Report that you want to run. There will be an option top select Database Configuration.



Running Crystal Reports Database Login Needed in BI4 for Viewing
Running Crystal Reports Database Login Needed in BI4 for Viewing

Choose this option and a page will appear allowing you to set the database credentials. Change the drop down to "Use same db login as when report is run" and specify the custom details for the report

 
You should then be able to use the OpenDocument link to view the Crystal Report without a login box for the database appearing

No comments:

Post a Comment