Skip to Content
0
Former Member
Mar 06, 2009 at 03:08 PM

Suppressing repeated group names in sorted list

7 Views

I have a report with four groups: Customer, Class, Type and Item, sorting in that order. I need to get counts at the Item level. In displaying the counts, I want to print the Customer, Class, Type and Item all on the first line, with the total for that combination, then if there are additional Items for that Customer/Class/Type combination the next line would only print the new Item name, and not the Customer, Class or Type as they have not changed, etc. The Customer, Class and Type should only print when their value changes since the previous line. All I can do now is either repeat all the names on each line, or have each of the four print on separate lines. Can someone help? Thanks!