Skip to main content
Contact a Moderator

Question

3
Replies
811
Views
 Ravi Kumar Pisupati (Ravi Kumar Pisupati) Optum Principal LSA - Pega
Optum
US
Ravi Kumar Pisupati Member since 2015 90 posts
Optum
Posted: October 17, 2017
Last activity: February 14, 2018
Posted: 17 Oct 2017 13:54 EDT
Last activity: 14 Feb 2018 14:41 EST
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 Enterprise Application Development Dev/Designer Studio System Administration Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 4 years ago
Posted: 18 Oct 2017 4:21 EDT
Shibani Sahu (ShibaniSahu) PEGA Manager of Software Engineering, Case Management
Pegasystems Inc.
IN

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: 4 years ago
Posted: 18 Oct 2017 10:49 EDT
Ravi Kumar Pisupati (Ravi Kumar Pisupati) Optum Principal LSA - Pega
Optum
US

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.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice