OpenFileDialog file = new OpenFileDialog(); file.Filter = "Report Files (*.rpt)|*.rpt"; if (file.ShowDialog() == DialogResult.OK) { report_file = (string)file.FileName; } //setDatabaseSettings(); TableLogOnInfo crtableLogoninfo = new TableLogOnInfo(); ConnectionInfo crConnectionInfo = new ConnectionInfo(); Tables CrTables; ReportDoc.Load(report_file); crConnectionInfo.ServerName = "XYZPC\\XYZ"; crConnectionInfo.DatabaseName = "RME01"; crConnectionInfo.UserID = "sa"; object pwd = "123"; crConnectionInfo.Password.Equals(pwd); CrTables = ReportDoc.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in CrTables) { crtableLogoninfo = CrTable.LogOnInfo; crtableLogoninfo.ConnectionInfo = crConnectionInfo; CrTable.ApplyLogOnInfo(crtableLogoninfo); } crystalReportViewer1.ReportSource = ReportDoc; crystalReportViewer1.Refresh();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)