In my Project I am trying to open a Crystal report after writing the Dataset values to the XML file, but after loading the Report when I try to open it throws the Exception Database Logon Failed
I had tried with the following code,
protected void getpkeys_Click(object sender, EventArgs e)
{
try
{
ReportDocument rpt = new ReportDocument();
DataSet ds = Namespace.SP.Storedprocedure_Select().GetDataSet();
if (ds.Tables[0].Rows.Count > 0)
{
ds.WriteXml(Server.MapPath("~/XMLReports/Passkeys.xml"));
string filename = Server.MapPath("~/Path/Upload/Pkey_rpt.rpt");
rpt.Load(filename);
rpt.SetDataSource(ds);
rpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "ExportedReport");
}
}
catch (Exception ex)
{
ClientMessaging(ex.Message);
}
}