Question
ING Bank
NL
Last activity: 5 Jun 2023 22:22 EDT
Requestor level Datapage limiting the results of report definition. Result count mismatch
Hi Everyone,
- We have requestor level datapage, it is editable.
- It is sourced with Report Definition.
- Report definition when executed standalone, fetches more than 5K+ rows.
- There is Pagination enabled on report and no limit has been set on max no of rows to retrieve
- However when we execute from DataPage, it is limiting result count to 1500 rows.
Datapage-> Limit to single datapage option has been checked.
We have verified earlier PDN posts, few suggest to update DSS setting to MRUCapacity , but it will impact the other datapages and have an impact on performance.
How can i show the rest rows? and what exactly is the reason for datapage showing limited records?
Bits in Glass
IN
@subramanyamJsb can you saveas pymaxrecords application setting rule to your application ruleset and modify it's value and try? After changing, once log off and login and try running the dpage again. It should work.
Updated: 5 Jun 2023 22:22 EDT
NCS Pte. Ltd
SG
Hi @subramanyamJsb: MRUCapacity is not the configuration controlling the max number of results in Data page. Please check the application settings rule "pyMaxRecords" which will control this.
If you want to get all the records you can update the "pyMaxRecords" Application settings. Please note that this will be applicable to all the data pages getting values from report definitions. If you want the change to be specific to your data page, you need to uncheck pagination option and need to update "Maximum number of rows to retrieve" in the report definition.
Alternate option is to call activity in the data page and to update pyReportParamPageName to set pyMaxRecords as required and call pxRetrieveReportData.
Please also check this for some additional details.
Thanks.