is there a way to remove duplicates from a report?

[a99920]

I have a report that tells me all users who have a particular role but users can be listed many times (depending on how many groups they are in that the role might have been inherited from).

[Srinivas Balusu]

Did you try Group by

[a99920]

I'm not sure I follow. What would I group by? How would this eliminate duplicates?

[Srinivas Balusu]

This is what I tried in my instance. I got only one record with multiple roles. Can you post a screen shot of what you are looking for?

[ian_cox]

This is a tricky one, because they are not really duplicates. ie ian has admin from the developer group and ian has admin from the system admin group.   They are 2 records.   or ian was granted admin today and ian was granted admin yesterday are 2 records.   I normally put them into excel to remove the dupes.