Report grouping and subtotals
Posted on 2013-09-23
Dear experts -
I have ca. 16 complex totals that display in a group footer - these (I learned the hard way) are not calculated 'on-the-fly', but each is the sum of a field calculated already in the SQL record source.
NOW - I have a subgrouping, before we get to the major grouping. The totals appear JUST FINE in these subgroupings.
For example, let's say the major group is by person, and we have Joe, Mary, Katie.
Within each person, we have a job type: type 1, 2, 3. (It is a finite list of just 3).
I would like to display the subtotals for job TOGETHER, in the group footer.
Is there some way to do this that does not require me to create ANOTHER 48 FIELDS in the record source (!) - can I do something like have the subtotal on the report, but make it invisible and then display that value in the group footer?
Thanks for your counsel!