Question
pzViewExportToExcel activity is not returning all the records from the used Report Definition
Hi,
We have a excel report generation using the following navigation.
Main activity -> Call pzViewExportToExcel -> Call the Report Definition of Enable Paging feature with 200 records on each page -> Generates excel and send an email with the attached report excel
After we ran this in PRD, we have > 1000 records from RD but we see 200 records of data (Page-1) only. In non PRD environment, we cleared out the Enable Paging option from the RD and ran the activity manually and we see all the records are pulled into the excel.
Now the question is like - is there any limitation in the product behavior (RD) to pull all records if we disable paging option? If not, what is the fix we can apply based on the performance impact in mind.
We are using PRPC V7.2.2.
Thanks,
Ravi Kumar.
Hello,
While running pzViewExportToExcel activity on Report definition with pagination enabled, steppage itslef holds rows equal to the pagination number as RD fetches that many record at one go.So excel shows that many records only.
With disabled pagination, steppage gets all rows due to which all record gets exported to excel .
While running activity, check for pyReportContentPage(in case of OOTb report).