I am using VS2010 in vb.net
I have created a Crystal Report that links to the a SQL Server 2008 R2 database by OLEdb connection. The report has been created in the integrated report writing tool in VS2010.
The report runs fine when previewing and prompts for password that I enter and then returns the data as expected.
I have now loaded the report into a CrystalReportViewer on a form. When I run the form it prompts for the password. It stores, Server, Database and User Name but not the password. This I need to pass so the user is does not have to enter a password.
How do I pass these details?
