Click here to Skip to main content
14,697,444 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
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 c#.net or vb.net)?
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
Posted
Updated 27-Jul-12 4:07am
v5

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

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


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

http://www.codeproject.com/script/Articles/ArticleVersion.aspx?waid=32615&aid=439697
   

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