Suppress an order if it doesn't contain a particular item.
I have a report that groups as such:
Line Item Number
I currently do a lot of collapsing and bucketing, but I don't see where that would affect my new need.
I want to be able to enter a Product number and if that Product doesn't that product isn't on either the Line or the Line Item, then I want to suppress that Order, and all of its detail.
I believe I've worked through something similar by setting a variable associated with the record as it's being selected, but I don't recall how I filtered after that, and associated it with an Order Number.