Support Article
Export to Excel from report definition fails for 100K rows
SA-92304
Summary
When increasing the maximum number of rows to 100K, the report fails while exporting to Excel.
Error Messages
Not Applicable
Steps to Reproduce
- Select the report definition rule for ServiceStats.
- Navigate to Actions and click Run.
- Change the Filter to 'Last 30 Days' and Apply the changes.
- Click Export to Excel. The Excel report displays only the default of 10000 rows.
- Private Edit the report definition.
- For the Data Access, set the 'Maximum number of rows for export' to '100000' and Save.
- Navigate to Actions and click Run.
- Change the Filter to 'Last 30 Days' and Apply the changes.
- Click Export to Excel.
Root Cause
A defect in Pegasystems’ code or rules
When a large report was exported to Excel, it exceeded the 64K limit on cell styles in Excel.
Resolution
This feature is implemented in Pega Platform 8.2.5.
Published November 29, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.