Support Article
Export to Excel occurs without Distinct clause
SA-27473
Summary
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.
Error Messages
Not Applicable
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.
Root Cause
Activity pzRDExportWrapper does not consider Remove duplicate rows option.
Resolution
Apply HFix-29246.
Published September 14, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.