protected void btnPDF_Click(object sender, System.EventArgs e)
{
try
{
string tempFile = Session.SessionID.ToString();
PerformSearch();
PerformDataBind();
LoadReport();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=" + tempFile + ".pdf");
MemoryStream oStream; // using System.IO
oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
Response.BinaryWrite(oStream.ToArray());
}
catch { }
finally
{
rsm.CloseReportDocumnet();
Response.Flush();
Response.End();
}
}
protected void btnPDFExport_Click(object sender, EventArgs e)
{
FreightEasy.Accounting.APDispute myDs = new FreightEasy.Accounting.APDispute();
myDs.GetAllRecords(elt_account_number, Session["VENDOR"].ToString(),
Session["SDATE"].ToString(), Session["EDATE"].ToString());
DataSet ds = myDs;
ReportSourceManager rsm = null;
try
{
rsm = new ReportSourceManager();
rsm.LoadDataSet(ds);
rsm.LoadCompanyInfo(elt_account_number, Server.MapPath("../../../ClientLogos/" + elt_account_number + ".jpg"));
rsm.WriteXSD(Server.MapPath("../../../CrystalReportResources/xsd/APDispute.xsd"));
rsm.BindNow(Server.MapPath("../../../CrystalReportResources/rpt/APDispute.rpt"));
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=APDispute_" + System.DateTime.Today.ToString("yyyy-MM-dd") + ".pdf");
MemoryStream oStream;
oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
Response.BinaryWrite(oStream.ToArray());
}
catch { }
finally
{
rsm.CloseReportDocumnet();
Response.Flush();
Response.End();
}
}
protected void PDFPrintButton_Click(object sender, EventArgs e)
{
PerformSearch();
try
{
rsm = new ReportSourceManager();
rsm.LoadDataSet(ds);
rsm.LoadCompanyInfo(elt_account_number, Server.MapPath("../../ClientLogos/" + elt_account_number + ".jpg"));
rsm.LoadOtherInfo(AddFilter());
rsm.WriteXSD(Server.MapPath("../../CrystalReportResources/xsd/customer_recap.xsd"));
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/customer_recap.rpt"));
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=customer_recap_" + System.DateTime.Today.ToString("yyyy-MM-dd") + ".pdf");
MemoryStream oStream;
oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
Response.BinaryWrite(oStream.ToArray());
}
catch { }
finally
{
rsm.CloseReportDocumnet();
Response.Flush();
Response.End();
}
}
protected void PDFPrintButton_Click(object sender, EventArgs e)
{
MakeDataSet("SOList", Session["currentSQL"].ToString());
try
{
rsm = new ReportSourceManager();
rsm.LoadDataSet(ds);
rsm.LoadCompanyInfo(elt_account_number, Server.MapPath("../../ClientLogos/" + elt_account_number + ".jpg"));
// XSD file is automatically gerated
rsm.WriteXSD(Server.MapPath("../../CrystalReportResources/xsd/OnhandReport.xsd"));
// This file needs to be created
if (check1.Checked == true)
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/OnhandReport_customer.rpt"));
}
else
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/OnhandReport1.rpt"));
}
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=onhand_report.pdf");
//MemoryStream oStream; // using System.IO
//oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
//Response.BinaryWrite(oStream.ToArray());
var rpt = rsm.getReportDocument();
System.IO.Stream oStream = null;
byte[] byteArray = null;
oStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(byteArray);
Response.Flush();
Response.Close();
Response.End();
rpt.Close();
rpt.Dispose();
}
catch { }
finally
{
rsm.CloseReportDocumnet();
Response.Flush();
Response.End();
}
}
protected void ExportToPDF(object sender, System.EventArgs e)
{
string tempFile = Session.SessionID.ToString();
sqlText = OrgSqlText + " order by " + orderKey;
BindToDataSet("organization");
LoadReport();
//rsm.getReportDocument().ExportToHttpResponse(ExportFormatType.PortableDocFormat, Response, true, tempFile);
//rsm.CloseReportDocumnet();
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=" + tempFile + ".pdf");
MemoryStream oStream; // using System.IO
oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
rsm.CloseReportDocumnet();
Response.BinaryWrite(oStream.ToArray());
Response.Flush();
Response.End();
}
protected void ExcelPrintButton_Click(object sender, EventArgs e)
{
MakeDataSet("WrOutTable", Session["WrOutSQL"].ToString());
MakeDataSet("WrInTable", Session["WrInSQL"].ToString());
MakeDataSet("WrInOutTable", Session["WrInOutSQL"].ToString());
try
{
rsm = new ReportSourceManager();
rsm.LoadDataSet(ds);
rsm.LoadCompanyInfo(elt_account_number, Server.MapPath("../../../ClientLogos/" + elt_account_number + ".jpg"));
rsm.WriteXSD(Server.MapPath("../../CrystalReportResources/xsd/WrInOut.xsd"));
if (check1.Checked == true)
{
if (listResultSelect.SelectedIndex == 1)
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WarehouseINReport_customer.rpt"));
}
else if (listResultSelect.SelectedIndex == 2)
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WarehouseOUTReport_customer.rpt"));
}
else
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WRInOut_customer.rpt"));
}
}
else
{
if (listResultSelect.SelectedIndex == 1)
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WarehouseINReport.rpt"));
}
else if (listResultSelect.SelectedIndex == 2)
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WarehouseOUTReport.rpt"));
}
else
{
rsm.BindNow(Server.MapPath("../../CrystalReportResources/rpt/WRInOut.rpt"));
}
}
Response.Clear();
Response.Buffer = true;
Response.ContentType = "application/pdf";
Response.AddHeader("Content-Type", "application/pdf");
Response.AddHeader("Content-disposition", "attachment;filename=In_and_Out.xls");
//MemoryStream oStream; // using System.IO
//oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.Excel);
//Response.BinaryWrite(oStream.ToArray());
var rpt = rsm.getReportDocument();
System.IO.Stream oStream = null;
byte[] byteArray = null;
oStream = rpt.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
byteArray = new byte[oStream.Length];
oStream.Read(byteArray, 0, Convert.ToInt32(oStream.Length - 1));
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = "application/pdf";
Response.BinaryWrite(byteArray);
Response.Flush();
Response.Close();
Response.End();
rpt.Close();
rpt.Dispose();
}
catch { }
finally
{
rsm.CloseReportDocumnet();
Response.Flush();
Response.End();
}
}
