I have 4 fields.
Now i want to display only duplicates employee name and dob(only duplicates not all the employee)
I have used the report studio and i group but it display all with duplicates and non duplicates.
This topic has been locked.
1 reply Latest Post - 2013-02-07T15:33:31Z by DanielWagemann
Pinned topic Want to display only duplicates
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-02-07T15:33:31Z at 2013-02-07T15:33:31Z by DanielWagemann
DanielWagemann 2700058MAJ411 PostsACCEPTED ANSWER
Re: Want to display only duplicates2013-02-07T15:33:31Z in response to SystemAdminAssuming you are on a relational data source you could group on EmployeeName and DOB, then do a running-count on DOB. Any duplicate values would have a running-count greater than 1. This means you could filter on running-count >1