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.