Is it possible to create report to check duplicates?

[mansi.kakkar]

I would like to create a report to find out if A (Varchar) which is a unique value, is used in other records of the entity or not.

[yuri]

You can find examples on our demo.

[mansi.kakkar]

That worked, thanks yuri !
Also, is there a way to create a report that compares two date values? For example, date A shouldn't be greater than date B. So, I need to create a report to see if there are any records where date A > date B.

[castigation]

Ah, so the solution is to create a grid report to count the values and then filter out which have greater than 1 count value.

Honestly we wouldn't have figured it out ourself, thanks!