I am using CR 11.5 with MSSQL 2000. I have a report that includes a subreport that pulls information from a different database than the main report. When I run the report through my .net application, it requests a password for the secondary database. If I supply the password, the report will run correctly, however, I cannot give out the password to regular users.
Is there a way to supply the password for the secondary database within the application?