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