Crystal Reports Select only Unique ID

Question

I have a report that is pulling an ID field. I want to use the select expert to say if an ID is duplicated, do not pull this data. I know I can use format field, suppress if duplicated, but I don't want the data to be pulled in the first place, if possible.

How would I do this?

Thanks.

Answer 1

Please check below listed solutions. I usually try one by one of this solution, because different issue may have different solution. But so far, I can say that most of duplicate issue solve by query (last solution)

1) checkbox suppress if duplicate 2) Distinct 3) Grouping 3) SQL Query (The best)