Example #1
0
        private void LoadReport()
        {
            rsm = new ReportSourceManager();
            DataColumn col = null;

            string[] str = new string[10];

            str[0] = Session["Accounting_sPeriod"].ToString();
            str[1] = Request.Cookies["CurrentUserInfo"]["login_name"];
            str[2] = Session["PNLkey"].ToString();
            string rsType = Request.QueryString["rs"];

            string elt_num = Request.Cookies["CurrentUserInfo"]["elt_account_number"];

            try
            {
                rsm.LoadDataSet(ds);
                rsm.LoadCompanyInfo(elt_num, Server.MapPath("../../../ClientLogos/" + elt_num + ".jpg"));
                rsm.LoadOtherInfo(str);
                rsm.WriteXSD(Server.MapPath("../../../CrystalReportResources/xsd/pnl.xsd"));

                rsm.TableRename("Invoice", "cTmp");

                if (!rsm.BindNow(Server.MapPath("../../../CrystalReportResources/rpt/pnl_" + rsType + ".rpt")))
                {
                    Response.Write("failed to bind");
                    Response.End();
                }
            }
            catch (Exception e)
            {
                Response.Write(e.ToString());
                Response.End();
            }
        }
Example #2
0
    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();
        }
    }
Example #3
0
    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();
        }
    }
Example #4
0
    protected void SENDMAIL(object sender, EventArgs e)
    {
        PerformSearch();
        string fileLocation = "C://temp//Customer_daily_Recap_" + System.DateTime.Today.ToString("yyyy-MM-dd") + ".pdf";
        string orgNum       = hCustomerAcct.Value.ToString();

        if (orgNum != "" && orgNum != "0")
        {
            try
            {
                File.Delete(fileLocation);
                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();
                MemoryStream oStream;
                oStream = (MemoryStream)rsm.getReportDocument().ExportToStream(ExportFormatType.PortableDocFormat);
                FileStream fs = new FileStream(fileLocation, FileMode.CreateNew, FileAccess.Write);
                fs.Write(oStream.ToArray(), 0, oStream.ToArray().Length);
                fs.Close();
                oStream.Close();
            }
            catch { }
            finally
            {
                //rsm.CloseReportDocumnet();
                Response.Flush();
            }
            reload.Value = "Y";
        }
    }
Example #5
0
    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();
        }
    }
Example #6
0
    private void LoadReport()
    {
        rsm = new ReportSourceManager();

        try
        {
            rsm.LoadDataSet(ds);
            rsm.WriteXSD(Server.MapPath("../../../CrystalReportResources/xsd/CompanySearch.xsd"));
            rsm.BindNow(Server.MapPath("../../../CrystalReportResources/rpt/CompanySearch.rpt"));
        }
        catch (Exception e)
        {
            Response.Write("Failed to Load");
            Response.End();
        }
    }
Example #7
0
    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();
        }
    }