Related content:

Question Report Definition Displays all the records Question Report Definition is not fetching all the records from table Question Report Definition not fetching all the records from the table without pagination Question Record count using report definition to run in an activity Question Report Definition is not returning results from Implementation classes Question ConvertResultsToCSV method not returning calculated column values from a Report Definition Question Report Definition : Return rows containing max value Question what can I use instead of using report definition in a activity? Question Report Definition. The data source from clipboard. Question Not able to identify the source of data returned from the call Rule-Obj-Report-Definition.pxRetrieveSearchData in an activity
Contact a Moderator

Question

3
Replies
728
Views
Ravi Kumar Pisupati Member since 2015 74 posts
Optum
Posted: 2 years ago
Last activity: 2 years 11 months ago
Closed

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.

Low-Code App Development Low-Code App Development Dev/Designer Studio System Administration Reporting
Close popover
Moderation Team has archived post
Posted: 2 years ago

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

Posted: 2 years ago

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.


Thanks,


Ravi Kumar.
Share this page LinkedIn
Copied!