I have a crystal report that i am displaying using a ReportSource from crystal enterprise server 10.
This report has On Demand Sub Reports in it. When a user clicks on the web viewer to view that sub report it prompts for Database logon information. How do i set this information server side so the user is not prompted?
I wanted to follow up on this question, since it was not properly answered. If you are using the enterprise SDK, and veing a report Stored on the server you must change the properties of the report on the server itself for what I needed to work.
Once the report is saved to crystal enterpise go into the report's properties.
go to Process->Database and set the following setting:
In Crystal 10 - Make sure 'Prompt the user for database logon when viewing' is
In Crystal XI - under 'When viewing report:' make sure the radio button for
'Use same database logon as when report is run' is checked.
Also, the SDK has a 'Prompt on refresh' optoin when scheduling the report programmatically that you can set to false to make this work without having to change the base report in the crystal enterprise server. (This goes for Crysal XI and Crystal 10)