private void Btn_Excel_Click(object sender, EventArgs e) { SaveFileDialog Archivo = new SaveFileDialog(); if (Archivo.ShowDialog() == DialogResult.OK) { CrystalDecisions.Shared.ExportOptions Opt = new CrystalDecisions.Shared.ExportOptions(); CrystalDecisions.Shared.ExcelFormatOptions Opt_Exc = new CrystalDecisions.Shared.ExcelFormatOptions(); CrystalDecisions.Shared.DiskFileDestinationOptions Opt_Dsk = new CrystalDecisions.Shared.DiskFileDestinationOptions(); Opt.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel; Opt.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile; Opt_Exc.ExcelUseConstantColumnWidth = false; Opt.ExportFormatOptions = Opt_Exc; Opt_Dsk.DiskFileName = Archivo.FileName; Opt.ExportDestinationOptions = Opt_Dsk; Reporte.Export(Opt); } }
private void frmManageMenu_Load(object sender, EventArgs e) { this.Text = "Reporting"; if (clientnamE == "PO") { this.Text = clientnamE + " event"; CrystalReport2 eventss = new CrystalReport2(); eventss.SetDataSource(eventDetails); CrystalDecisions.Shared.ExcelFormatOptions XLSFormatOptions = new CrystalDecisions.Shared.ExcelFormatOptions(); XLSFormatOptions.ShowGridLines = true; XLSFormatOptions.ExportPageBreaksForEachPage = true; crystalReportViewer1.ReportSource = eventss; } else if (clientnamE == "Summary") { this.Text = clientnamE + " event"; SummaryReport eventss = new SummaryReport(); eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } else if (clientnamE == "OverallReport") { this.Text = "Selected events Summary"; OverallReport eventss = new OverallReport(); eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } else { CrystalReport1 eventss = new CrystalReport1(); int exportFormatFlags = (int)(CrystalDecisions.Shared.ViewerExportFormats.PdfFormat | CrystalDecisions.Shared.ViewerExportFormats.ExcelFormat); crystalReportViewer1.AllowedExportFormats = exportFormatFlags; eventss.SetDataSource(eventDetails); crystalReportViewer1.ReportSource = eventss; } }