2283071 - Duplicated rows on Table (Ad Hoc) Reports

• You run a Table report and get duplicates in the Table Report result.
• How to remove Duplicated rows in Ad Hoc Reports?

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

SAP SuccessFactors HCM Suite

1. Create a Table Report of any domain (example: Performance Management, Employee Profile, Recruiting, etc.)
2. Select the Columns from Column tab
3. You are seeing the duplicates in the report for the selected columns

There can be multiple reason for duplicates in Table reports such as missing (not including) a column that has unique value for the set of columns you have selected.

We have provided a feature called "Enable Distinct" to remove the duplicates in Adhoc report.

1. Open Reporting
2. Go to edit the report
3. Go to Columns tab
4. You will see a checkbox called "Enable Distinct". Once you check that and save the report, duplicates will be removed from the Report.

2145834 - Table and Detailed Reports Show Multiple Rows Per User Even with Enable Distinct/Hide Duplicate Rows Option Enabled

Ad,hoc, Reports, Duplicates, records, Enable, Distinct, remove, table, center , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , How To