Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I blank out certain things?

Status
Not open for further replies.

grecon

Technical User
Mar 8, 2007
78
US
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?
 
One more thing on my example it may look confusing cause the customer I am using as a reference has 4 items that happen to be the same code.
 
If these fields are in the detail section, you could select the fields you only want to appear once->right click->Format field->check "suppress if duplicated".

You could alternatively insert a group on customer number or name and place the customer info in the group header. If you want the info aligned, you could format the GH to "underlay following sections."

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top