Remove duplicates on a list report?

[Rom]

Hello,

I'm reporting on the User Roles table to view which users have which roles. There are a lot of duplicates due to roles being granted from different groups and some roles being inherited from other roles. I'm trying to display unique values only when I'm reporting on this and to remove any of the duplicates from the list. I'm sure that removing duplicates in an excel would be easier, but I have a requirement to display the information on the reporting module itself. I've seen on other threads that this can be done through a javascript call from a script include in a report filter, but I've had no luck with this so far.

Group by can work, but would still prefer omitting duplicates from the list.

Some help with this is appreciated!

Thanks everyone!

[Jaspal Singh]

You can check for Report Type: Single Score & pass required Role in the filter. That would give you a unique set of Users with that role. Simple, quick & efficient. 

[Rom]

Thanks Jaspal! I would still prefer it in a list view though

[Bhavana Reddy]

Did u get the solution, if so please help me here i also need to remove duplicates in the list report