Excel Download limit in report browser
How to know the limit of exporting excel in report browser? Assume the DB have 1 lac above records
When downloaded from the data type records then all the records downloaded in csv where as while exporting to excel from report browser around 30K record downloaded . Why can not we download all the records while exporting to excel from report browser. Checked by modifying the value in Data access of DataTableEditorReport
Maantic Inc
US
Hi, Are you updated Maximum number of rows to retrieve and Maximum number of rows for export in report definfiion data access tab?
Pegasystems Inc.
US
You need to consider the settings for both the maximum number of rows to export and the maximum elapsed time to export. These can be set either on the report definition itself or as system defaults through Configure > Reporting > Settings.
You should understand that the reporting facilities in Pega are meant to support interactive reports, not bulk exports. 100K plus records are a lot to export through a report definition. It will take time and may consume a lot of memory. You should seriously consider using BIX to do this instead.