COGNOS: INCREASING THE NUMBER OF ROWS IN MS-EXCEL OUTPUT

Cognos allow us to view the report output in different format including MS-Excel 2007.

By default Cognos allow us to display 65000 rows in MS-Excel, but this can be increased

up to 1048576 rows. We can achieve this by doing some changes at Cognos administrator

level. Here are the simple steps

- Open Cognos Administrator
- Select System under Status tab
- Click on BatchReportService. Click on Set Property and set the following variables


RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET - true
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS - 1048576

- Run the report in MS-Excel format and you will be able to display upto 1048576 records
in a sheet.