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.
Re: horizontal data in crystal reports
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.
Re: horizontal data in crystal reports
Cross tab report will definately solve the problem, Suppress Summery fields/Section