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
***Edited by Moderator: Pooja to change content type from Discussion to Question, add platform capability tag***
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.