Troubleshooting
Problem
When exporting a list report to Excel 2007 format, the output is exported to multiple Worksheets after 65,536 rows. How can this limit be changed to allow all rows exported to a single Worksheet?
Cause
By default Cognos limits number of rows exported to Excel Worksheets to maintain compatibility for older Microsoft Excel versions.
Resolving The Problem
Advanced parameter RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS is available to configure Cognos to export to the maximum rows to an Excel Worksheet, 1,048,576 rows.
RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET=TRUE
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS=1048576
Documentation for configuring the Advanced Parameter
- Configuring the report and batch report services to use large worksheets
Another option is to Export to CSV and open in Excel. Note that this exports the query results and will not export charts, crosstab and report formatting.
Documentation for configuring the Advanced Parameter
- Configuring the report and batch report services to use large worksheets
Another option is to Export to CSV and open in Excel. Note that this exports the query results and will not export charts, crosstab and report formatting.
Related Information
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Component":"Cognos Viewer","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.x.x;11.x.x","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
24 October 2019
UID
swg21419957