I am new to the site and crystal reports. I am using crystal reports for vs 2010 and programming in c#
I have an old database which has user login credentials stored in a separate database (workgroup security?). I can connect to it via c# by passing the login details to the .mdw file and the main database in the connection string.
I can also (in design view) connect to the database and produce a report.
However when I try running the report at runtime, I am being asked for login details... and even after providing the details is does not connect..
I connect using this method in design time:
but i cannot find any information on how to connect at runtime... Where do I set the session username, session password and system database?
my code to connect looks a bit like this:
ReportDocument cryRpt = new ReportDocument();
TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();
TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();
ConnectionInfo crConnectionInfo = new ConnectionInfo();
string path = Application.StartupPath;
cryRpt.Load(path + "\\" + report);
crConnectionInfo.UserID = "someuser";
crConnectionInfo.Password = "password";
crConnectionInfo.ServerName = "z:\\main_database.mdb";
CrTables = cryRpt.Database.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables)
crtableLogoninfo = CrTable.LogOnInfo;
crtableLogoninfo.ConnectionInfo = crConnectionInfo;
if (parameter != "")
crvMain.ReportSource = cryRpt;
I am losing the will to live trying to find the solution to this, can anyone help??