Filter across two tables for report

[Devin]

I'm needing to do a sub summary report.

I've got for this example two Tables.. Orders and Lineitems.

In the Orders Table their is 

orderID and status.b

and the lineItems has orderID, sku, qty.

With a relationship between the two Tables that match "orderID".

The status.b is number filed that will contain a 0, 1 or 2. Deepening on the status of that order.

 

What I want to do is build a report that gives me a sub summary of all the sku items and the qty sum of only the records were the status.b = 0 in the table Orders.

I can build the report now but getting the filtering to work is where I'm stuck. 

 

Thanks

[webko]

At the LineItems level, can't you perform a find for Orders::status.b = 0 and then sort for the report?

 

[Devin]

OMG... What was I thinking.

I was looking for a much harder way to do this... I guess simpler is sometimes better.

Thanks