Topic
1 reply Latest Post - ‏2013-02-07T15:33:31Z by DanielWagemann
SystemAdmin
SystemAdmin
15496 Posts
ACCEPTED ANSWER

Pinned topic Want to display only duplicates

‏2013-02-07T06:49:55Z |
HI,

I have 4 fields.
1.Employee name
2.Emp dob
3.Emp address

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.

Thanks
Updated on 2013-02-07T15:33:31Z at 2013-02-07T15:33:31Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    411 Posts
    ACCEPTED ANSWER

    Re: Want to display only duplicates

    ‏2013-02-07T15:33:31Z  in response to SystemAdmin
    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