Filtering products supplied to a customer

SOLVED

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