private void download_leaves(int id, int rid)
{
bus.lid = id;
DataTable dt = bus.fetch_download_leaves();
int reg = rid;
if (dt.Rows.Count > 0)
{
if (reg == 2)
{
rd.Load(Server.MapPath(Request.ApplicationPath) + "/user/approved.rpt");
rd.SetDataSource(dt);
// location of empty pdf file
string exportPath = Server.MapPath("~/pdf/Approved_Leave.pdf");
// export the report to pdf and write to empty pdf file inside pdf folder
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = exportPath;
CrExportOptions = rd.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rd.Export();
Response.Redirect("~/ViewPdf?reportFile=" + exportPath);
}
else if (reg == 1)
{
rd.Load(Server.MapPath(Request.ApplicationPath) + "/user/approved_malaysia.rpt");
rd.SetDataSource(dt);
// location of empty pdf file
string exportPath = Server.MapPath("~/pdf/Approved_Leave.pdf");
// export the report to pdf and write to empty pdf file inside pdf folder
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = exportPath;
CrExportOptions = rd.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rd.Export();
Response.Redirect("~/ViewPdf?reportFile=" + exportPath);
}
}
}
