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(); }