Question
Cognizant
US
Last activity: 26 Jun 2017 12:14 EDT
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.
Infosys
AU
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.
Cognizant
US
Thank you for prompt answer.
Accepted Solution
Capgemini
IN
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
Cognizant
US
Thank you for prompt answer.