Grouping methods

[Justin Lee]

There are basically 2 ways to display a grouping.  In a report, you can display it with the group titles in their own row like this:

Group 1
    XXXXXXX   XXXXXXX   XXXXXXX
    XXXXXXX   XXXXXXX   XXXXXXX
Group 2
    XXXXXXX   XXXXXXX   XXXXXXX

In a crosstab, you can display it with the group titles as a column. Like this:
Group 1     XXXXXXXX   XXXXXXXX   XXXXXXXX
                  XXXXXXXX   XXXXXXXX   XXXXXXXX
Group 2     XXXXXXXX   XXXXXXXX   XXXXXXXX

Is there a way to do both in the same report?
i.e.

Grouping 1
      SubGroup 1     XXXXXXXX   XXXXXXXX   XXXXXXXX
                              XXXXXXXX   XXXXXXXX   XXXXXXXX
      SubGroup 2     XXXXXXXX   XXXXXXXX   XXXXXXXX
                              XXXXXXXX   XXXXXXXX   XXXXXXXX
Grouping 2
      SubGroup 1     XXXXXXXX   XXXXXXXX   XXXXXXXX
                              XXXXXXXX XXXXXXXX XXXXXXXX
      SubGroup 2     XXXXXXXX   XXXXXXXX   XXXXXXXX


I can't seem to find a way to do this with a crosstab or with the report group explorer.
Thanks,
Justin

[Hadib Ahmabi]

You actually can do this with crosstab but I don't see the point in doing it. What I would do is to group the report to achieve the outer grouping and in the detail section put a crosstab to get the sub-grouping.