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.
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 Posts
Re: Want to display only duplicates2013-02-07T15:33:31ZThis is the accepted answer. This is the accepted answer.Assuming 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