SYMPTOMS

When exporting a Cognos report with many rows to Excel, it happens that the data is distributed into several worksheets. How can it be achieved to get all data into a single worksheet?


RESOLUTION

To do so, an administrator needs to change two Cognos system parameters:

RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS
to
1048576

RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET
to
true

It needs to be done for Cognos ReportService and BatchReportService.