WJM
asked on
How to not show duplicate records SSRS
I have a report on employee headcount, I am trying to show the distinct count of employees along with their information and their room assignment; however, some employees are assigned multiple rooms and therefore show up more than once, I would like to see the multiple rooms; however, I only want to see the employee listed one time. I am attaching an image that will hopefully help. I don't know if it's Friday or my head still being in Crystal Reports but I'm missing how to set this up properly in SSRS/BIDS, thank you.
Bill
Bill
Can you post your query?
you can change your backend query to concate the room number separated by comma or any delimeter provided that values in other columns are same.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you everyone.
Nicobo, it was the hide duplicates feature that worked for me. In order to get my count properly I used
=CountDistinct(Fields!EMPI D.Value)
This way it didn't add the duplicate values if the employees were assigned multiple rooms. Thanks again for your help.
Bill
Nicobo, it was the hide duplicates feature that worked for me. In order to get my count properly I used
=CountDistinct(Fields!EMPI
This way it didn't add the duplicate values if the employees were assigned multiple rooms. Thanks again for your help.
Bill