
My Code
cryRpt.SetDatabaseLogon(UserName, Password, ServerName, DatabaseName);
string OutputPDFFileName = @"E:\temp\" + DateTime.Now.ToString("mmddyyyyHHMMss") + ".pdf";
cryRpt.DataSourceConnections[0].IntegratedSecurity = false;
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.RefreshReport();
cryRpt.DataSourceConnections[0].IntegratedSecurity = false;
crystalReportViewer1.ReportSource = cryRpt;
crystalReportViewer1.RefreshReport();
cryRpt.ExportToDisk(ExportFormatType.PortableDocFormat, OutputPDFFileName);
How to stop the DSN Login Screen
Vasanth NatarajanPosted Jul 27, 2017, 9:48 AM
objReportDocument.Load(strpaths);
crConnectionInfo.AllowCustomConnection = true;
crConnectionInfo.DatabaseName = strDatabase;
crConnectionInfo.UserID = strUserName;
crConnectionInfo.Password = strPassword;
TableLogOnInfo crTableLogoninfo = new TableLogOnInfo();
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in objReportDocument.Database.Tables)
{
crTableLogoninfo = CrTable.LogOnInfo;
crTableLogoninfo.ConnectionInfo = crConnectionInfo;
CrTable.ApplyLogOnInfo(crTableLogoninfo);
}
crystalReportViewer1.Cursor = Cursors.WaitCursor;
objReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, OutputPDFFileName);
Vasanth NatarajanPosted Jul 19, 2017, 3:16 AM
Manikandan MurugesanPosted Jul 17, 2017, 8:46 PM