Grouping Data 1

[kuberacupidagra]

Hello All,

I have grouped the below data by T_CWOC. I can drill down the Work Center and get details of T_PRTM and T_AHMC. Both T_PRTM and T_AHMC are summed fields. There are some other fields in the report which are formula fields.


Work Center Department Production Time Man Hours
(T_CWOC) (T_Dept) (T_PRTM) (T_AHMC)

MMJ03 652 .742 .53
MMP04 667 2.323 1.2
MMP13 667 .415 .34
MMP17 667 .396 .45
MMP18 667 .793 .60
MMS03 662 1.772 1.6
MMS07 662 3.084 3.3
MMS10 662 .369 .29
WAR02 652 .66 .62

T_CWOC and T_DEPT are string fields
T_PRTM and T_AHMC are numeric fields

I have removed T_CWOC from the report for printing but the group on T_CWOC still exits. I now want to group records using T_DEPT field inside T_CWOC group. T_DEPT was a numeric field which I converted to string.

I tried creating another group on T_DEPT but it does not give the required results. T_CWOC and T_DEPT are from different tables. The tables are joined by T_CWOC field.

I would appreciate help and direction to solve this.

Thanks,

AA

 

[lbass]

Can't tell what the problem is. Perhaps you should show a sample of the results you are getting after grouping on dept along with a sample of how you think the results should look.

-LB

 

[Madawc]

Crystal will let you group T_DEPT within T_CWOC, or vice versa. If you want to see the same details grouped two different ways, you can't do that within a Crystal report.

Two possible solutions that I can see:

1) A crosstap, a grid of values for T_DEPT against T_CWOC that Crystal will create automatically, Insert > Crosstab.

2) A subreport in the report header or report footer. THis is an independent report and can group the same data in a different way.

PS. It's helpful to give your Crystal version.

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