Too many records per ID 1

[Ladyazh]

I have data that looks like this

ID ProductWanted ProductPurchased
12 aaa aaa
13 aaa ccc
13 aaa bbb

My goal is if there is more then 1 product exists per ID - I need to not to show it.
I need to show only 1 product per ID.
I can write this in SQL Server or Crystal. But I do not see how.

Thanks

 

[lbass]

Group on ID and place the fields in the group header. Then suppress the detail section.

-LB

 

[Ladyazh]

Thanks as always!