Reports: Count/retrive Distinct records on list report

[GD11]

I have a custom table which has ID field, I want to have list report filter on distinct ID's as ID's are duplicate, is there any way do it?

list editing is already enabled on sys_report table

[Mike_R]

This is the best solution i have seen

https://snprotips.com/blog/rvicenowprotips.com/2015/12/detecting-duplicate-records-with.html

[GD11]

Hi @Mike_R  this is returning both records , how can I filter out one of them? i used both getValue and getUniqueValue as well but did not work, getting id=undefined, do you have any thoughts.

[Mike_R]

Ah, I misread your question. I thought you wanted to find a list of duplicates. Scrap the above solution, as that is only for detecting duplicates. 

What if you group the report by id? Would that work for you?

[GD11]

Hi @Mike_R  No, I want to send report in excel, so group by will not work, I wanted to remove duplicates.