as far as I know, you have to create a db user with the dbreader role. This user needs a blank password.
In your report use this user to connect to the db . If you then add this report with this user in the servicedesk application, you are not asked for a password again.
Hope that helps.
1 of 1 people found this helpful
A read only account can be created with no password to run the reports under (recommended in the guide below in ADDENDUM 1 – Create a reporting database login in SQL):
The other way is to specify the password in the reports configuration in the Crystal Report component.
If the location of your reports is specified at a network location such as \\drive\share the password does not carry across the network the prompt for the password is shown.
However this works better if you map a drive reports (or use an existing one) such as V:\reports and store the reports in that location. All users accessing the report need to be access to the location. Then set the default path for the reports to the mapped network location.