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