I have searched for this answer but nothing I find seems to answer it.

OK I have an sql database with a table that generates the following when I run my stored procedure:

ITEM ITEM NUMBER WPS NAME TEST RESULTS DATE
ISO1 1 234 Smith xxx Pass 4/10/2010
ISO1 1 234 Smith yyy Pass 4/10/2010
ISO1 1 234 Jones zzz Pass 4/10/2010
ISO1 2 235 Smith xxx Fail 4/10/2010
ISO1 2 235 Smith zzz Pass 4/10/2010
ISO2 1 234 Jones zzz Pass 4/11/2010
ect

I want to display on my report the following

ITEM ITEM NUMBER WPS NAME
TEST
RESULTS
DATE

i.e....

ISO1 1 234 Smith Smith Jones
xxx yyy zzz
Pass Pass Pass
4/10/2010 4/10/2010 4/10/2010

ISO1 2 235 Smith Smith
xxx zzz
Fail Pass
4/10/2010 4/10/2010

ISO2 1 234 Jones
zzz
Pass
4/11/2010
ect....

I have tried cross tab and sub-reports without the correct results.
Using a cross tab report I can get it close but I can not get rid of the row totals which make the results look jacked up.

Can anyone help me?
Thanks.