CR2008 - Count Once for Multiple values

[pndMaster]

Hello,

I have a scenario, where client can have more than one Race like below

ClientId Client Name Client Datebirth Client Race
100 John, Smith 01/01/1980 White
100 John, Smith 01/01/1980 AmericanIndian
101 John, Dose 03/01/1977 Black
102 Doe, John 01/23/1983 Asian
102 Doe, John 01/23/1983 White

I would like to know how to show the client in only one group, for example if client got counted in White then i dont want him to again appear under american indian

White
100 John, Smith 01/01/1980
102 Doe, John 01/23/1983
Count: 2
Black
101 John, Dose 03/01/1977 Black
Count: 1

AmericanIndian
Count: 0

Asian
Count: 0


Appreciate your guidance and feedback

Thanks

 

[pndMaster]

I have posted this in Crystal Reports.

Thanks