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);
}
}