Need To Filter Distinct Data - Report Studio

[kdub72]

I have what I hope is a simple issue. Say I have thousands of customers, each may or may not have multiple accounts. I want to do a mailing. The distinct field will be SSN#.

CustomerA SSN#A Account1A AddressA
CustomerA SSN#A Account2A AddressA
CustomerB SSN#B Account1B AddressB
CustomerB SSN#B Account2B AddressB
CustomerC SSN#C Account1C AddressC

I would like to only see three lines when I run the query. The Account# is not needed -- all I really care about is the Customer, SSN#, and Address.

Any tips would be greatly appreciated. Thanks!

 

[kdub72]

Nevermind -- I got it. Since the account # is not needed, I just left it out of the query, but still filtered by Open Accounts. I didn't think it would work without an Account #.