Question

4
Replies
5729
Views
 Sreenivasa Rao Kilaru (SreenivasKilaru)
Cognizant

Cognizant
US
SreenivasKilaru Member since 2014 20 posts
Cognizant
Posted: June 25, 2017
Last activity: June 26, 2017
Posted: 25 Jun 2017 19:36 EDT
Last activity: 26 Jun 2017 12:13 EDT
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.

Data Integration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 26 Jun 2017 6:54 EDT
Swarnendu Mukherjee (SwarnenduM)
Infosys
Technology Architect
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. 

Accepted Solution

Posted: 3 years ago
Posted: 26 Jun 2017 9:06 EDT
Saikat Chakrabortty (Saikat_Chakrabortty)
Capgemini
Pega Developer
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