Do I use a cross-tab for this?

[Budjette]

Hi everyone,

I have a table in SQL that looks like this.
Type Crew Date Monday Tuesday Wednesday Thursay ...
Hours 14027 10/14/02 55.67 67.89 48.60 48.50
WO 14027 10/14/02 68.78 34.56 23.45 23.45
Ress 14027 10/14/02 45.67 23.45 56.78 56.78

Hours 14030 10/14/02 58.34 18.34 49.56 39.67
WO 14030 10/14/02 79.89 23.45 59.67 39.56
Ress 14030 10/14/02 34.56 67.34 79.89 45.78
.
.
.
I have to create a report that looks like that table group by crew. I don't need to see the date. It should look like this:
Monday Tuesday Wednesday Thursday
Hours 55.67 67.89 48.60 48.50
WO 68.78 34.56 23.45 23.45
Ress 45.67 23.45 56.78 56.78

Hours 58.34 18.34 49.56 39.67
WO 79.89 23.45 59.67 39.56
Ress 34.56 67.34 79.89 45.78

Do I need to use a cross-tab to do this?

Thanks,

Budjette

 

[ardentdev]

No, you don't need to use a cross-tab report for that. You can just use a standard report.

 

[kenhamady]

Group by Crew, and then by type.
Add 5 subtotals, one from each day of the week. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com