Apologies if this is the wrong sort of thing to post.  I've had a search and couldn't find an answer.

I would like to, in SupportCenter Plus, create a query report which lists all accounts which have an active contract associated with them.  I realise it's easy enough to create a matrix report which shows you all accounts where contract status is valid, but it repeats the account name where they have multiple contracts.

Any thoughts?

Thanks, James.