Export to excel with repeat grid causes duplicate rows
Developer has created a section containing repeat grid (with report definition as the source) and a custom button for Exporting the Grid results to excel. Export does work as expected for one of the sections. Excel shows duplicate rows. Export worked fine before updating to Pega 7.1.8.
No error messages, but there are duplicate rows in excel.
Steps to Reproduce
1. Create a repeat grid with report as source.
2. Create a custom button to export the results to excel.
The root cause of this problem is a defect in customer application code/rules. The problem occurs across browsers. The activity to export to excel was customized and incorrect.
This issue is resolved through the following local-change:
Configure a button to use the below activity for exporting the grids/reports results to excel.
One must ensure that appropriate access is given on the activity's security tab.