How can remove duplicated records from report

[I_aki_Maria]

Hello experts,

I need to know all users who are managers from my Company.

To obtain it, I have created a report using table [sys_user]  with fields:company,department and manager. But the problem is that I obtain duplicated reports (as many as the number of users managed by each manager). How could I remove this records from  my report? How could I obtain this report with only one record per manager?

Thanks in advance!

[Andrew_TND · Accepted solution]

It depends you can run a background script to remove the duplicates otherwise a less drastic approach would be if 'Duplicate' is mentioned in the closure codes just add a condition that says 'Close code (is not) Duplicate'.

Let me know if this answers your question.