[RESOLVED] Crystal counting and supressing groups.

[BIGGY]

This seems pretty basic, however has turned into a bit of a catch. I'm looking at some customer orders, and the only ones that interest me are ones where the complete order did not ship on the same day (part one day and part another). At the moment the report groups as follows:

#1 Customer Number
#2 Ship Date
#3 Order number.

Now the order number field (SOHeader.OrdNbr), will appear on every line in the detail section, or basically every line number. So suppressing based on a formula such as "Count({soheader.ordnbr}) < 2" won't work because every order that has more than one order line will still show. I basically want to supress all orders that don't show up more than once in group #2. For example...

Order ABC has a ship date of only 5/1/2006. And order XYZ shipped on 5/1/2006 and 5/2/2006. Order ABC should not show and XYZ should show.

Thanks in advance for any input!

[BIGGY]

I took and counted a flag on each order (USHP) which is marked when an order is shipped. If an order is shipped more than once (which is what happens with backorders), then there will be multiple USHP flags. So I simply suppress the group if the count is less than 2 and that will show me all old backorders.