CR v8
I have 2 tables
Billing.Detail (invoice #, customer number, product code, description, order quantity, sale price, etc…)
Products (products code, description, text2, amount1, amount2, etc…)
Tables are linked by product code.
I can get it to tell my what products a given customer orders, (run a report that groups prodicts, than customer with the detail band hidden). Now how do I get to tell me the products that that they don’t order? Products that don’t match products pulled by the last report?
I have 2 tables
Billing.Detail (invoice #, customer number, product code, description, order quantity, sale price, etc…)
Products (products code, description, text2, amount1, amount2, etc…)
Tables are linked by product code.
I can get it to tell my what products a given customer orders, (run a report that groups prodicts, than customer with the detail band hidden). Now how do I get to tell me the products that that they don’t order? Products that don’t match products pulled by the last report?