How to export to a excel file with just one worksheet

[Former Member]

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

[Former Member]

Hi Valmir,

are you using BPC MS version? If not please close the thread and repoen it in the right forum otherwise please explain your BPC and Excel version.

Regards

     Roberto