When i export 85000 lines from sqlserver to excel....crystal creates two worksheet , but my client want all data at just one
there's any configuration to do this ??
string directory = server.MapPath("~/Temp") + "/" + idUser;
string directoryArq = server.MapPath("~/Relatorios/") + rel;
ReportDocument cryRpt;
cryRpt = new ReportDocument();
cryRpt.Load(directoryArq);
IDataReader rs = new DLLPadrao.Factory().GetDataReader("select xxxxxx");
cryRpt.SetDataSource(rs);
cryRpt.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.ExcelWorkbook, response2, true, "relatorio");