Crystal Report Asking for Login Credentials

Hi all

Thank you for your replies. But sorry to say that it was all my mistake. I  apologize for this, as the mistake i made was that the name of database in localhost and in client database got changed. So it was asking login details.

 

Sorry again for this and thank for taking time and replying my post. 

Thanks friends.

 

now just a query how to close this thread. so no one will not reply to this query

Hi i think your DSN Connection is Cleared so try this this working for me

 

 //DSN Connection Reseted

ReportDocument objReportDocument = new ReportDocument();

objReportDocument.Load(strpaths);

ConnectionInfo crConnectionInfo = new ConnectionInfo();

crConnectionInfo.LogonProperties.Remove(crConnectionInfo);
crConnectionInfo.AllowCustomConnection = true;
crConnectionInfo.IntegratedSecurity = true;
crConnectionInfo.ServerName = strDSNName;
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;
}

for (int i = 0; i < objReportDocument.Subreports.Count; i++)
{
foreach (CrystalDecisions.CrystalReports.Engine.Table CrTable in objReportDocument.Subreports[0].Database.Tables)
{
crTableLogoninfo = CrTable.LogOnInfo;
crTableLogoninfo.ConnectionInfo = crConnectionInfo;
}
} 

 

 

 if (objReportDocument.DataSourceConnections.Count > 0)
{
objReportDocument.DataSourceConnections[0].IntegratedSecurity = false;
}
for (int i = 0; i < objReportDocument.Subreports.Count; i++)
{
objReportDocument.Subreports[i].DataSourceConnections[0].IntegratedSecurity = false;
}
crystalReportViewer1.ReportSource = objReportDocument;
crystalReportViewer1.RefreshReport();
crystalReportViewer1.Visible = false;
objReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, OutputPDFFileName);

Dear Post Snapshot as well for the better understanding of your Problem.

 

Thanks...