public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CRReporteSociosParaExportar rpt = new CRReporteSociosParaExportar(); rpt.Site = this.Site; return(rpt); }
private async void button2_Click(object sender, EventArgs e) { try { if (saveFileDialog1.ShowDialog() == DialogResult.OK) { DeshabilitarButtons(); IniciarProgressBar(); string nomArchivo = saveFileDialog1.FileName; SqlConnectionStringBuilder sqlStrBuilder = new SqlConnectionStringBuilder(ObtenerCadenaConexionAppController()); //http://aspalliance.com/478_Exporting_to_Excel_in_Crystal_Reports_NET__Perfect_Excel_Exports.3 //https://www.c-sharpcorner.com/UploadFile/mahesh/savefiledialog-in-C-Sharp/ CRReporteSociosParaExportar reporte = new CRReporteSociosParaExportar(); //reporte.SetDatabaseLogon("sa", "modomixto", "CRUZ2-THINK", "DBCajaCuentas2"); reporte.SetDatabaseLogon(sqlStrBuilder.UserID, sqlStrBuilder.Password, sqlStrBuilder.DataSource, sqlStrBuilder.InitialCatalog); reporte.SetParameterValue("@parametroNoNecesario", true); // Declare variables and get the export options. ExportOptions exportOpts = new ExportOptions(); ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions(); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); exportOpts = reporte.ExportOptions; // Set the excel format options. excelFormatOpts.ExcelUseConstantColumnWidth = false; excelFormatOpts.ShowGridLines = true; //exportOpts.ExportFormatType = ExportFormatType.ExcelRecord; exportOpts.ExportFormatType = ExportFormatType.Excel; exportOpts.FormatOptions = excelFormatOpts; // Set the disk file options and export. exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; //diskOpts.DiskFileName = "miotroreporttttte.xls"; diskOpts.DiskFileName = nomArchivo; exportOpts.DestinationOptions = diskOpts; reporte.Export(); await Task.Delay(10); DetenerProgressBar(); HabilitarButtons(); MessageBox.Show("Exportacion lista", "Resultado de operación", MessageBoxButtons.OK, MessageBoxIcon.Information); } } catch (Exception ex) { DetenerProgressBar(); HabilitarButtons(); MessageBox.Show(ex.Message + " " + ex.Source + " " + ex.StackTrace); } }