Crosstab with multiple groups

[SuperTime]

Crystal 9
SQL DB

My crosstab in the report footer currently looks like:

Prod1 Prod2 Prod3 etc...
AVDH 2 0 1
WarehouseError 2 0 1
WrongSize 2 0 1
AVDH 0 4 0
WarehouseError 0 4 0
WrongType 0 4 0
AVDH 1 0 0
WarehouseError 1 0 0
Missing 1 0 0
AVDH 1 1 1
ProductionError 1 1 1
WrongColor 1 1 1
AVDH 0 0 2
ProductionError 0 0 2
WrongSize 0 0 2
AVDH 1 1 0
ProductionError 1 1 0
Missing 1 1 0
CBW 1 1 0
ProductionError 1 1 0
Missing 1 1 0

But I want it to be grouped together as follows alongwith subtotals:

Prod1 Prod2 Prod3 etc...
AVDH
WarehouseError
WrongSize 2 0 1
WrongType 0 4 0
Missing 1 0 0
Subtotals 3 4 1
ProductionError
WrongColor 1 1 1
WrongSize 0 0 2
Missing 1 1 0
Subtotals 2 2 3
CBW
ProductionError
Missing 1 1 0
Subtotals 1 1 0

etc...

Please advice

 

[CrysRptDev]

Hi SuperTime,

Base on sample that you posted earlier. Did you try to get rid out of the boxes around first and second group? i tried by check on Indent Row Labels in Customize Labels and check on Column Total on Top..uncheck Row Total on left.

 

[lbass]

CrysRptDev,

Please start a new thread, instead of piggybacking here. I don't really follow what your issue is with the boxes. If you want to get rid of gridlines, you can go to the customize style tab->format grid lines and then eliminate the ones you don't want.

-LB

 

[CrysRptDev]

Hi LB,

I thought my question is just to add more information to SuperTime's crosstab table so that you can follow my question. I guess it might make you confuse!?

My issue with the boxes is that instead of drill-down like SuperTime's sample:

Prod1 Prod2 Prod3 etc...
AVDH
WarehouseError
WrongSize 2 0 1
WrongType 0 4 0
Missing 1 0 0
Subtotals 3 4 1
ProductionError
WrongColor 1 1 1
WrongSize 0 0 2
Missing 1 1 0
Subtotals 2 2 3
CBW
ProductionError
Missing 1 1 0
Subtotals 1 1 0



But I will see some spacing boxes that crosstab has like below:

Prod1 Prod2 Prod3 etc...
AVDH WarehouseError WrongSize 2 0 1
WrongType 0 4 0
Missing 1 0 0
Subtotals 3 4 1
ProductionError
WrongColor 1 1 1
WrongSize 0 0 2
Missing 1 1 0
Subtotals 2 2 3
CBW ProductionError Missing 1 1 0
Subtotals 1 1 0

 

[lbass]

If you want that kind of control, you'll have to use a manual crosstab.

-LB

 

[CrysRptDev]

That what I tried to explain before. It works for me without using a manual crosstab.

Thanks SuperTime for using your thread and sorry for lots of my posts here.

Thanks LB for your reply and your help!