private void bntExprtPDF_Click(object sender, EventArgs e) { // todo : fix the save file problem (fixed and now works properly) Emad .. Feb 2, 2018 try { lblState.Text = "جاري الحفظ ..."; Reports.rpt_all_products allProductsCrystalRpt = new Reports.rpt_all_products(); // refresh the report (clear any binded params, if the report was used before and already has a binded param) allProductsCrystalRpt.Refresh(); //create export report options ExportOptions exprtOpts = new ExportOptions(); DiskFileDestinationOptions dfOptions = new DiskFileDestinationOptions(); PdfFormatOptions pdfFrmtOps = new PdfFormatOptions(); SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "حفظ قائمة المنتجات"; sfd.Filter = "PDF files (*.pdf)|*.pdf|All files (*.*)|*.*"; sfd.CheckPathExists = true; sfd.ShowDialog(); //MessageBox.Show(sfd.FileName); // bind the result "address of file as a string" to the dfOptions object of (DiskFileDestinationOptions dfOptions = new DiskFileDestinationOptions();) dfOptions.DiskFileName = sfd.FileName; exprtOpts = allProductsCrystalRpt.ExportOptions; exprtOpts.ExportDestinationType = ExportDestinationType.DiskFile; exprtOpts.ExportFormatType = ExportFormatType.PortableDocFormat; exprtOpts.ExportFormatOptions = pdfFrmtOps; exprtOpts.ExportDestinationOptions = dfOptions; allProductsCrystalRpt.Export(); lblState.Text = "تم الحفظ بنجاح"; } catch (UnauthorizedAccessException) { MessageBox.Show("ليس لديك صلاحية لحفظ الملف في هذا المسار. من فضلك اختر مسار مختلف", "خطا بالصلاحية", MessageBoxButtons.OK, MessageBoxIcon.Error); lblState.Text = ".."; } }
// export the report to an excel sheet private void btnExprtExcel_Click(object sender, EventArgs e) { // todo : fix the save file problem try { lblState.Text = "جاري الحفظ ..."; Reports.rpt_all_products allProductsCrystalRpt = new Reports.rpt_all_products(); //create export report options ExportOptions exprtOpts = new ExportOptions(); DiskFileDestinationOptions dfOptions = new DiskFileDestinationOptions(); ExcelFormatOptions exlFrmtOps = new ExcelFormatOptions(); SaveFileDialog sfd = new SaveFileDialog(); sfd.Title = "حفظ قائمة المنتجات"; sfd.Filter = "excel files (*.xls)|*.xls|All files (*.*)|*.*"; sfd.CheckPathExists = true; sfd.ShowDialog(); //MessageBox.Show(sfd.FileName); dfOptions.DiskFileName = sfd.FileName; exprtOpts = allProductsCrystalRpt.ExportOptions; exprtOpts.ExportDestinationType = ExportDestinationType.DiskFile; exprtOpts.ExportFormatType = ExportFormatType.Excel; exprtOpts.ExportFormatOptions = exlFrmtOps; exprtOpts.ExportDestinationOptions = dfOptions; allProductsCrystalRpt.Export(); lblState.Text = "تم الحفظ بنجاح"; } catch (UnauthorizedAccessException) { MessageBox.Show("ليس لديك صلاحية لحفظ الملف في هذا المسار. من فضلك اختر مسار مختلف", "خطا بالصلاحية", MessageBoxButtons.OK, MessageBoxIcon.Error); } }