Grouping in Crystal Reports crosstab

Question

I'm using Crystal Reports XI R2 and want to build a table using crosstab functionality to display some data. The trouble is I don't want grouping on rows, eg. I want all rows (except the period) to be displayed underneath each other and not one row be a subgroup of another) I want it to look like this:

Period 1
       Group 1  value 1 | Summary field
       Group 1  value 2 | Summary field
       Group 1  value 3 | Summary field
       Group 2  value 1 | Summary field
       Group 2  value 2 | Summary field
       Group 3  value 1 | Summary field
       Group 3  value 2 | Summary field
       Group 3  value 3 | Summary field

Period 2
       Group 1  value 1 | Summary field
       Group 1  value 2 | Summary field
       Group 1  value 3 | Summary field

...

Instead of this:

Period 1
       Group 1 value 1 | Group 2 value 1 | Group 3 value 1 | Summary field 
                                         | Group 3 value 2 | Summary field 
                                         | Group 3 value 3 | Summary field 
                       | Group 2 value 2 | Group 3 value 1 | Summary field 
                                         | Group 3 value 2 | Summary field 
                                         | Group 3 value 3 | Summary field 

       Group 1 value 2 | Group 2 value 1 | Group 3 value 1 | Summary field 
                                         | Group 3 value 2 | Summary field 
                                         | Group 3 value 3 | Summary field 
                       | Group 2 value 2 | Group 3 value 1 | Summary field 
                                         | Group 3 value 2 | Summary field 

                                         | Group 3 value 3 | Summary field 
Period 2
       Group 1 value 1 | Group 2 value 1 | Group 3 value 1 | Summary field 
                                         | Group 3 value 2 | Summary field 
                                         | Group 3 value 3 | Summary field 

...

I want to group my data on Group 1 Field only (period, selected by the user, so it can by grouped by days, weeks, months, years - I already have a formula to work it out). The other fields are:

• Group 2 (Flight Service Type, eg. Scheduled, charter, transfer etc.),

• Group 3 (Airport Group Type, eg: Schengen/Non-Schengen, Continents,
  GCC/Non-GCC etc - those are defined by the user)

• Group 4 (Flight direction - either Departure or Arrival).

As you can see, those three groups are not related to each other and each Flight belongs to ALL 3 of those groups (Eg. Flight A is Scheduled (group 2), Schengen (group 3) and Arrival (group 4)), and that's where I think the problem is.

Can this be achieved in Crystal Reports XI R2 using cross tabs?

Answer 1

Because these things aren't related you will need to move flight service, airport group, and flight direction to individual sub-reports (one for each). Place each sub-report in a separate GH1 section (i.e. GH1b, GH1c, GH1d)--GH1a will contain the group name and summary field.

You'll group the data in each sub-report as desired.

You can link the main report to each sub-report if you want to correlate the data.