Question
4
Replies
5430
Views
Cognizant
Posted: June 25, 2017
Last activity: June 26, 2017
Closed
Solved
How to configure maximum number of records to retrieve in report definition
Report definition needs to be called from data page or activity. How to pass parameter to specify the "maximum number of records to retrieve" value which is in Data Access tab?
Thanks in advance.
Accepted Solution
Posted: 3 years ago
Hi,
I dont think there is any easy wayt of doing it. Only way I can think of is, create one activity which would be responsible for getting the records from the report.
Now in that activity, open the report defination by obj-Open and then set the property which do store the number of records to retrieve(Reportpage.pyUI.pyMaxRecords).
Now Call Rule-Obj-Report-Definition.pxRetrieveReportData and pass the report page as parameter of the activity. It should work.
-Saikat
I think this cannot be done straight away; these values would be hardcoded into the report at design time. Instead you will likely need to use a SQL connect rule and pass these values in as params or may be you have to customize the RD activity while retrieving records.