Specific criteria - but need to display entire associated record(s) 1

[aj3221]

I am pulling an order file and looking for a specific item number. If I find that item number, I want to display all of the lines on that order. I can't think of how to do this. If I narrow it down by the specific item number, then I only get that line, not all of the lines on the order. Can you help?

Example below - I want to pull any order with item # XXX123 on it, and display all the line on that order.

{OrderNo} {Line} {Item}
12345-00 1 ABC123
12345-00 2 DEF123
12345-00 3 XXX123

Thanks in advance!

 

[IanWaterman]

Group Report by order number

Create formula
@Item
If itemfield = 'XXX123' then 1 else 0

In Group Select
Max(@item) = 1

Any order which does not have XXX123 will be suppressed

Ian

 

[aj3221]

I can't believe I didn't think of that! I do that exact thing on another report. Ugh. Thanks so much!