private void button7_Click(object sender, EventArgs e)
{
this.dataGridView1.DataSource = prd.GET_ALL_PRODUCTS();
RPT.RPT_ALL_PRD myReport = new RPT.RPT_ALL_PRD();
//Create Export Options
ExportOptions export = new ExportOptions();
//Create Object For Destination
DiskFileDestinationOptions dfOptionXLS = new DiskFileDestinationOptions();
DiskFileDestinationOptions dfOptionPDF = new DiskFileDestinationOptions();
PdfFormatOptions pdfFormat = new PdfFormatOptions();
ExcelFormatOptions excelFormat = new ExcelFormatOptions();
//Set The Path of Destination For XLS
saveFileDialog1.Filter = "Text Files | *.XLS";
saveFileDialog1.InitialDirectory = "D:\\";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
dfOptionXLS.DiskFileName = saveFileDialog1.FileName;
}
//dfOptionXLS.DiskFileName = @"D:\PRODUCTLIST.xls";
export = myReport.ExportOptions;
export.ExportDestinationType = ExportDestinationType.DiskFile;
export.ExportFormatType = ExportFormatType.Excel;
export.ExportFormatOptions = excelFormat;
export.ExportDestinationOptions = dfOptionXLS;
myReport.Export();
MessageBox.Show("List XLS Exported Successfully", "Export", MessageBoxButtons.OK, MessageBoxIcon.Information);
//Set The Path of Destination For PDF
//dfOptionPDF.DiskFileName = @"D:\PRODUCTLIST.PDF";
saveFileDialog1.FileName = "";
saveFileDialog1.Filter = "Text Files | *.PDF";
saveFileDialog1.InitialDirectory = "D:\\";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
dfOptionPDF.DiskFileName = saveFileDialog1.FileName;
}
export = myReport.ExportOptions;
export.ExportDestinationType = ExportDestinationType.DiskFile;
export.ExportFormatType = ExportFormatType.PortableDocFormat;
export.ExportFormatOptions = pdfFormat;
export.ExportDestinationOptions = dfOptionPDF;
myReport.Export();
MessageBox.Show("List PDF Exported Successfully", "Export", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void button6_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_PRD myReport = new RPT.RPT_ALL_PRD();
RPT.FRM_RPT_PRODUCT myForm = new RPT.FRM_RPT_PRODUCT();
myForm.crystalReportViewer1.ReportSource = myReport;
myForm.ShowDialog();
}
