Skip to Content
0
Former Member
Jul 15, 2016 at 01:34 PM

How to export to a excel file with just one worksheet

83 Views

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