Return only one occurrence into a table report from multiple occurrences in a table.

I have a table that has, for simplicity,  a client name, related agency, related product and price.  One client can have many related agencies, and the agencies may have 1 to 5 products  (all 5 are t...