Get specific result set from Report Definitions using Index

General
,
1

Hello everyone!

I have a report definition returning 400 results. I am paginating this report with pages of 40 records. Suppose that I want to return only the page 4, with its records. How can I achieve that? Is that possible using Report Definition?

I tried to use Call Rule-Obj-Report-Definition.pxRetrieveReportData using the following parameters:

  • Created a report Param page callled ReportParams (Class Embed-QueryInputs) and set .pyPagingSettings.pyPageIndex = 4 and .pyPagingSettings.pyPageSize = 40.

image
image1248×530 50.5 KB

And I am passing these parameters before executing pxRetrieveReportData

image
image1120×612 42.9 KB

But I am getting a NullPointerException error on the ReportParams page.

Is that possible to return only the desired page from Report Definition with the result set?

Thanks in advance.