I’m trying to write a report that will show the # of orders for a customer and the # of orders with back orders.

Data looks something like this:

Cust       Order#                 Item#                    Qty BO

123         456                         A                             0

123         456                         B                             2

123         456                         C                             0

123         459                         A                             0

123         459                         B                             0

123         459                         C                             0

Summary would be 2 orders total and 1 order with a backorder

234         460                         A                             0

234         460                         B                             1

234         460                         C                             1

234         465                         A                             0

234         465                         B                             1

234         465                         C                             1

Summary would be 2 orders total and 2 orders with Back orders

Ideally I would like a Report summary section showing 4 orders and 3 backorders

Counting the orders is not an issue, counting the backorders is the problem.  I’ve tried formulas in the Order group footer that checks the sum of the Qty Bo field and returns 1 if the sum is >= 1 but then I cannot summarize that field in the customer group footer.