Manual Crosstab

[qcman]

I want to show the following

Monday Tuesday Wednesday
Team Car Team Car Team Car
01 7261 01 7233 01 7248
02 7264 02 7334 02 7658
03 7111 03 6555 03 6767

I can't use a crosstab because there are no calculations to be performed. I want the week days to go across the page rather than down

 

[IdoMillet]

Even if you don't need to do any calculations, you can still use CrossTabs. Just set the summary to maximum, minimum, or average. Assuming each cell contains a single value, it doesn't matter if you max, min, or average it -- it returns that value...

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[qcman]

That is a problem because some teams have more than one car per day.

 

[Madawc]

So group by team+car

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[qcman]

I'm not really sure what you mean. Could you explain it more in detail. Thanks

 

[Madawc]

Who's you? What I meant was a formual field that would be {team} & "/" {car}}. You could group by it, since it all comes from a single 'row'.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10