I did a report that shows customers and their invoice number along with the items they purchased, each item is on its own line and it also repeats the customer information for all the items. I only want the customer information listed once and then the items listed. I have attached a file what the report looks like and I drew a box around one of the customers that has multiple items on the same invoice, I want the customer information that I boxed not to show, just show the customer information and the item and then if there is more than one item I want the customer area to be blank, just list the item.
Any ideas how I can do this?
Any ideas how I can do this?