Need to surpress an entire row if part# is repeating

[Former Member]

what we need is if the part # repeats we need to not show the next row

i can do format on the column and say suppress if repeating.

But i want the entire row to be surpressed. they dont want to repeat the same part # row. So i sort according to order and part#, with order# as the group.

we want part# and qtyand on hand,  to be surpressed. but we can't say if qty is the same as the above row, that can be wrong.

Order:456

part#    qty[order       on hand

123      100                 1000

123       100                 1000

[abhilash_kumar · Accepted solution]

Hi Paul,

The easiest way to handle this is to insert a second group on the item# and move all fields to the group header.

If there are two different qtys for the item#, the report would only show the first one as it's being displayed on the group header.

-Abhilash