Hi,
I have tried to use the methods as posted by many experts on dynamically assigning the database and server login info into the code. However it is still prompting me to key in the login info. I had developed the database and server in an environment using different db name and server name from the client's side.
The following is my code on setting the login info.
CrystalReport1 rsource = new CrystalReport1();
rsource.SetDatabaseLogon("sa","sa","server1","db1");
for(int i=0;i<rsource.Database.Tables.Count;i++)
{
rsource.Database.Tables
.LogOnInfo.ConnectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
rsource.Database.Tables.LogOnInfo.ConnectionInfo= ci;
rsource.Database.Tables.ApplyLogOnInfo(logOnInfo);
}
this.crystalreportviewer1.reportsource = rsource;
Any advice is appreciated.
Crystal Report in Win form app in c#
John Paterson
hm...i sort of solve the problem.
I went to add the server as odbc system dsn to the client pc. then it work. not sure if this is correct. but it works at the moment.
If further advice is possible, greatly appreciated.