Posted: 17 Oct 2017 13:54 EDT Last activity: 14 Feb 2018 14:41 EST
pzViewExportToExcel activity is not returning all the records from the used Report Definition
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.
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).
Thank you Shibani for the reply. I checked all possible options but the question is like with enabled pagination we pull only first page from this activity call? I think there is no such restriction while running the RD directly and using the Export to Excel, if I am not wrong. Please chime in on how to make this activity running as it is like what we run directly from RD.