Report Grouping & Subtotals

[Debris]

Hello,

My app produces a list report with groups, and subtotals for those groups.

These groupings are fairly standard and repeatable. There's anywhere from
six to 10 groups, and I sort the groups in a standard sequence.

Group1
Data1
Data2
Data3
Subtotal, Group1

Group2
Data1
Data2
Subtotal, Group2

and so on. And there's a report footer grand-totaling everything.

My question is, is there a way "insert" a "subtotal" midway through the
list, say of Groups 1-6, then groups 7-8, then the grand total? These
subtotals would be "fixed" -- i.e., I would always subtotal groups 1-6, 7-8,
etc.

I know I can create a another level of grouping ("grouping" my groups) to
achieve the desired effect. However, that's more data to keep up with. I
was wondering if there's a way through the report setup or coding to
accomplish this.

Thanks in advance,

Debris

 

[Allen Browne]

Since your groups belong to larger groupings, create another table where you
define this:

1. Create a table named (say) SuperGroup, with one field of type Number
named SuperGroupID.

2. You probably already have a table of groups. Add a field to this table:
SuperGroupID Number
Now enter values in this field, so that groups 1-6 belong to SuperGroup 1,
groups 7-8 belong to SuperGroup 2, and so on.

3. In your report, insert the SuperGroupID as the highest grouping level (in
the Sorting And Grouping box.) You can now create a Group Footer on this
field, and get the SuperGroup totals.

(There's probably a better word than SuperGroup for your scenario, but
that's the concept.)