Support Article
Mashup report exports single record unless Mshup refreshed first
SA-84786
Summary
On opening a report from Pega Web Mashup and clicking Export to Excel, only one record displays even when there are multiple records.
However, on refreshing the Web Mashup main page, and opening the report and clicking Export to Excel, all the records display.
Export to Excel:

Only the first record displays.

After refreshing the page, opening the report and exporting to Excel, all the records display.

Error Messages
Not Applicable
Steps to Reproduce
- Open My Pages (Pega Web Mashup page).
- Launch the report definition using OpenURLInNewWindow with the activity containing the pxShowReport.
- Perform Export to Excel in the report.
Root Cause
The pzSetQueryDefaults activity was not invoked to initialize the pyReportSettings page on the pxRequestor when Pega Web Mashup was used. This also occurred for REST Services.
Resolution
As a local-change, invoke the pzSetQueryDefaults for the pxRequestorPage in the activity.
Published August 17, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.