9827398            Smith, Sandy            S5545

9929837            Brown, Dave             S2234

 

When I create my report, I just want to show the customers in the first portion of the report, and then list all orderID's associated with those customers in a different section.  My question is, how can I set this up so that I don't see Sandy Smith twice in my customer list?  Is there a way to only show unique records?

 

Thanks,

 

Hammerklavier