private void btnSavetoExcel_Click(object sender, EventArgs e) { try { RPT.rpt_AllProductN report = new RPT.rpt_AllProductN(); //choose destination for a report DiskFileDestinationOptions destination = new DiskFileDestinationOptions(); ExportOptions export = new ExportOptions(); ExcelFormatOptions excelFormat = new ExcelFormatOptions(); FolderBrowserDialog fd = new FolderBrowserDialog(); fd.ShowDialog(); string df = fd.SelectedPath + "\\report.xls"; // destination.DiskFileName = "D:\\report.xls"; destination.DiskFileName = df; export = report.ExportOptions; export.ExportDestinationType = ExportDestinationType.DiskFile; export.ExportFormatType = ExportFormatType.Excel; export.ExportDestinationOptions = destination; export.ExportFormatOptions = excelFormat; report.Export(); MessageBox.Show("تم تصدير الملف بنجاح"); } catch (Exception ex) { MessageBox.Show("لا يمكن الوصول الى قاعدة البيانات لتصدير الملف نحتاج الى الدخول في وضعية وثوقية الويندوز "); } }
private void btnPrintAllProduct_Click(object sender, EventArgs e) { RPT.RRM_Reports frm = new RPT.RRM_Reports(); RPT.rpt_AllProductN pr = new RPT.rpt_AllProductN(); frm.crystalReportViewer1.ReportSource = pr; frm.ShowDialog(); }