Question
Altimetrik
IN
Last activity: 15 Aug 2022 4:22 EDT
Report Defintion with Pagination
Hi All,
I have a report definition that brings around 500 results and so needed to use pagination.
We are displaying a custom section on Run of the report which has a download button which in turn runs activity (MSOGenerateExcel) to generate excel
But the generated excel seems to be producing only 50 results(results available on page index 1)
At the same time, the Export option available on Actions of the report definition seems to be generating the entire set of results
Is there any way to generate the entire set of results for report definition with pagination on the download button, or is there any possible way to reuse the run script of the export available in the action of report definition?
Capgemini
GB
You can do both options
1. To skip pagination when running a report and generating an Excel using the MSOExportToExcel activity.
The Rule-Obj-Report-Definition.pxRetrieveReportResults activity accepts a page name containing report parameters as its input params.
You can setup this page to disable pagination and then call pxRetrieveReportResults and it will return all results, then pass those results to the excel export activity.
2. You can call the same activity that the Report Viewer uses to export to excel. You will get a guardrail for this though, as the activity is marked as internal.
This will generate and download the file directly (you may need to run the activity on a section refresh from a button for it to download properly.
Updated: 14 Aug 2022 0:16 EDT
Infosys Limited
IN
As per the OOTB export to excel, it exports only the first page if the pagination is enabled. You can add a custom button which calls the activity that sets the maximum records and export the excel. Please find the below link which might be helpful for building the logic.
https://support.pega.com/question/how-export-excel-reports-pagination-enabled
Lventur
IN
Please refer pzSendEmailDigest OOTB activity which will be avail in Pega. In this activity Pega has included steps via which you could dynamically pull the needed count results from DB irrespective of pagination selected (or) not in report definition.
In Report Definition pagination will be enabled but while invoking the same report definition by using activity you can dynamically change the no.of results which needs to be fetch. Please refer 5.5 step which will show how dynamically you can change the parameters to fetch large results based on business need.
After Report Definition pulls the results from DB then you can have your logic to convert results into excel file.
Attached screenshot for reference.
