private void button6_Click(object sender, EventArgs e)
{
string filedes = @"D:\stock proj\Products.xls";
if (File.Exists(filedes))
{
File.Delete(filedes);
}
Reports.All_Products_Report report = new Reports.All_Products_Report();
report.Refresh();
//export options obj
ExportOptions ex = new ExportOptions();
//create disk obj
DiskFileDestinationOptions disk = new DiskFileDestinationOptions();
ExcelFormatOptions excel = new ExcelFormatOptions();
//set the path
disk.DiskFileName = @"D:\stock proj\Products.xls";
ex = report.ExportOptions;
ex.ExportDestinationType = ExportDestinationType.DiskFile;
ex.ExportFormatType = ExportFormatType.Excel;
ex.ExportFormatOptions = excel;
ex.ExportDestinationOptions = disk;
report.Export();
MessageBox.Show("Successfuly Stored", "Stored Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void button5_Click(object sender, EventArgs e)
{
Reports.All_Products_Report myrep = new Reports.All_Products_Report();
Reports.Product_Report form = new Reports.Product_Report();
myrep.Refresh();
form.crystalReportViewer1.ReportSource = myrep;
form.ShowDialog();
}
