locked
i write the pivot report my report is preview but not show the data then i attached my coding file RRS feed

  • Question

  • User-1808690281 posted

    beTest.Branch_Code = ddlBranch.SelectedValue.Trim();
    beTest.Month = Convert.ToInt32(ddlMonth.SelectedValue.Trim());
    beTest.Year = Convert.ToInt32(ddlYear.SelectedValue.Trim());
    DataSet ds = beTest.fetch();

    Random rn = new Random(10);
    string sPDF_File = Server.MapPath("~/pdffiles/" + rn.Next().ToString() + ".pdf");
    XtraReport report = new XtraReport();
    string sReport_File = "Test_Report_Count_Datewise";
    object instance = Activator.CreateInstance(BuildManager.GetType(sReport_File, true));
    report = (XtraReport)instance;
    report.DataSource = ds;
    report.DataMember = ds.Tables["Table"].TableName;
    PdfExportOptions pdfOptions = report.ExportOptions.Pdf;
    // Set PDF-specific export options.
    pdfOptions.Compressed = true;
    pdfOptions.ImageQuality = PdfJpegImageQuality.Low;
    pdfOptions.NeverEmbeddedFonts = "Tahoma;Courier New";
    report.ExportToPdf(sPDF_File);

    var web = new WebClient();
    byte[] bFile = web.DownloadData(sPDF_File);
    FileInfo fPdf_Delete = new FileInfo(sPDF_File);
    if (fPdf_Delete.Exists)
    {
    fPdf_Delete.Delete();
    }

    if (bFile != null)
    {
    Response.ContentType = "application/pdf";
    Response.AddHeader("content-length", bFile.Length.ToString());
    Response.BinaryWrite(bFile);
    }

    Wednesday, February 15, 2017 2:39 PM

Answers

All replies