horizontal data in crystal reports

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.

The only way to do it is with cross tabs. If you look around in the Cross Tab Expert, on the last tab (sorry, I can't remember the name right now), there is an option to suppress Row Total or Column Total.

Cross tab report will definately solve the problem, Suppress Summery fields/Section