Posted: 7 Feb 2017 9:58 EST Last activity: 8 Feb 2017 4:00 EST
Pega 7.2 - Report Definition using paging is only returning 500 records
We have a report definition with the paging option turned on. However, when running the report it only brings back a maximum of 500 rows. When we look at the XML under <pyContent> the max records is set to 500 (<pyMaxRecords>500</pyMaxRecords>).
It appears this is overriding or ignoring the pyPagingEnabled being set to true.
***Updated by moderator: Lochan to add Categories***
When "Enable paging" is checked in your report definition, "Maximum number of rows to retrieve" will be disabled. By default, the number is 500. You need to modify DSS setting "pyMaxRecords" to increase the value (eg. 1000). It can be accessed through SysAdmin > System Settings > search for pyMaxRecords".