Hi,
I'm looking to write a report in Report Designer which gives me information on the products that we supply to our customers.
I think there may already be a standard report that shows this but as far as I can see it lists sales to the customer so this means there will be duplicate instances in the report of a product that was sold.
What I require is a filtered list that shows each product once only in that list.
Is there an expression or filter that I can use to achieve this?
Thanks for your help in advance.
Kind Regards
Andy Stoneman