Few to many database issue

[ccoller]

I have customers that place orders (1 or more). Orders have items (1 or more). A total of three files.____I am trying to get a list of customers that have ordered a particular item.____Easy to do except the customer is listed once for every time they have ordered the item. I would like the customer to only appear in the list once regardless of how many times they have ordered the item.____Can it be done? If so, can someone point me in the right direction?____R&R Version 12.__

[kfleming]

Sort/group the report by customer number and put the information on a customer footer band rather than a record band.____Kathleen__R&R Support