Click here to Skip to main content
15,851,242 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I just want the code to change the database connection dynamically(changing server name and database name) without using the dataset or data table when connecting to a crystal report that works well in visual studio 2010 (either or
In other words I want to simply pass server name and database name from visual studio 2010 to crystal reports to generate report in a different server and database other than the report originally created, without using data set or data table in .net
Updated 27-Jul-12 4:07am

You can use SetDatabaseLogon() method exposed to set parameters of connection at runtime.

myCrystalReprot.SetDatabaseLogon("myUsername", "myPassword","servername","dbname");

C# Crystal Reports Dynamic Logon parameters [^]
MSDN: Using the SetDatabaseLogon() Method of the ReportDocument Class[^]
Share this answer
Reji Ab 28-Jul-12 1:39am    
SetDataBaseLogon() didn't work for me. Other code works, Thank you
See this Article
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900