protected void GenerateListOfRejectedLabels() { try { int productid = Convert.ToInt32(ddlproduct.SelectedValue); DataSet rptDS = new DataSet(); rptDoc = new ReportDocument(); CrystalReportViewer1.HasToggleGroupTreeButton = false; CrystalReportViewer1.BestFitPage = false; CrystalReportViewer1.Width = 920; DataTable dt = us_dll.GetListOfRejectedLabels(productid); if (dt.Rows.Count > 0) { rptDoc.Load(Server.MapPath("~/Reports/rptListOfRejectedLabels.rpt")); rptDoc.SetParameterValue("@PRODUCTID", productid); rptDoc.SetDataSource(dt); //rptDoc.SetDatabaseLogon("sa", "Pass2012", "GBLNJ4", "Sterilization"); rptDoc.SetDatabaseLogon("sa", "Pass2018", "pssql01", "PLSTEST1"); //rptDoc.DataSourceConnections[0].SetConnection("GBLNJ4", "Sterilization", "sa", "Pass2012"); rptDoc.DataSourceConnections[0].SetConnection("Pssql01", "PLS", "sa", "Pass2018"); CrystalReportViewer1.Page.Title = "List of Rejected Labels"; rptDoc.SummaryInfo.ReportTitle = "List of Rejected Labels"; CrystalReportViewer1.ReportSource = rptDoc; Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "application/pdf"; rptDoc.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Response, true, "List of Rejected Labels"); CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None; CrystalReportViewer1.SeparatePages = true; CrystalReportViewer1.DataBind(); CrystalReportViewer1.HasExportButton = false; Response.Flush(); Response.Close(); } else { ErrorMessage("Current selection does not have data"); } } catch (System.Threading.ThreadAbortException) { // ignore it } catch (Exception ex) { ErrorMessage(ex.Message); } }