I would like to show a report with all products sold on an invoice if one specific product is tagged. The report fields are Invoice_no and Stock_num. How is this done, what is the formula?

When I enter stock_num sold = "the product" it will only return invoices showing that specific stock number. I need all the products sold on that invoice to show as well. Please help.

Hi, I did everything you wrote right up to the last part,
when you wrote "Go into your select expert cahneg it to a ghroup Select and use your condition here
SUM(flag,Invoice_no)>0".

Are you saying to select the flag formula in select expert and enter "SUM(flag,Invoice_no)>0" as a formula entry?

Thanks again and sorry if I sound stupid.