DhilipkumarR1542 Member since 2019 1 post
Posted: 3 months ago
Last activity: 3 months ago

Report Definition not fetching all the records from the table without pagination

Hi Team,

We need to query around 80,000 of data from DB and process those records alos export the data into excel as well, we have used Report Definition to fetch the values, we are able to fetch the entire records when we use Pagination enabled, but for our legacy application needs an entire data result set to copy into another page reference to process the data, we are not able to fetch more than 10,000 records without pagination. We are getting timed out ,same for export to excel as well more than 10,000 records count to load we are getting timed out.


We have updated the Reports Settings(DesignerStudio->Reports-Setting) and in Report Definition Data Access tab as well.

Maximum number of rows to retrieve 50000

Maximum elapsed time (in seconds) for database query 300

Please provide any suggestion for the above need, we are using Pega 7.4 version.




Pega Platform 7.4 Reporting Financial Services
Share this page LinkedIn