Export to Excel occurs without Distinct clause
Export to Excel generates SQL query without Distinct clause. The records retrieved by the report definition and presented in Workbasket view are different from the records exported to Excel.
Steps to Reproduce
- Create a report definition with a link to another table (one to many relationship) and select Remove duplicate rows.
- Run this report through activity, and check the results.
- Call Export to Excel out-of-the-box pzRDExportWrapper activity and check the results.
Activity pzRDExportWrapper does not consider Remove duplicate rows option.
Published August 31, 2016 - Updated September 14, 2016