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?
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.
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.