horizontal data in crystal reports

[rdasca]

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.

[jade1977]

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.

[swaroopbhave]

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