How do I filter a record in the related to print report

I have a company table with related Invoices table (child) and related product sold tables (grandchild)

When I ran my report based on company data table, I can filter easily under condition field which company name I would like to run a report on, but this will report everything related to that company name.

What I would like is to be able to choose which company and which invoice ID to run the report on.
I manage to choose on company name and somehow cannot find the right expression to drill down to select Invoice ID and run into problem of cannot compare list with text.

any help on this would be appreciated. Thanks

0 1 171
1 REPLY 1

Steve
Platinum 4
Platinum 4

More details (in the form of screenshots, ideally) would be helpful.

Top Labels in this Space