Report Section Subtotal Value Retention

[jmh944911]

Greetings to all,
Sample for discussion - Final *look* of report:

PageHeader
Section1
S1 subtotal
Section2
S2 subtotal
TotalMass = S1sub+S2sub
Section3
Section4


Section1 and Section2 have subtotals values for a weight value. I want to retain these values so that I can add them together in the footer of section2 only. The sections are determined by dept and we are not interersted in the totals for 3 & 4 only the details. I plan to use condition formatting based on the dept number to hide or show the total line.
?
How do I retain the total for section 1 so that I may use it in section2?
?

All tips are welcome.
JMH944911

 

[jmh944911]

sorted it out

The running total value can be used to solve this problem. One keeps a local total and a running total of each group by turning off the the property for one textbox and on for another. With these two values one can keep track of each group subtotal.
Here is a small example:
PageHeader
Group1Hdr
Group2Hdr
Group2Ftr
textbox1, =sum[xyz1], local total, running off
textbox2, =sum[xyz1], running total, running on
textbox3, = (textbox2-text box1), previous group value, running off
textbox4, = ((textbox2-textbox1)/textbox2), %eff, running off
Group1Ftr
PageFtr

It is possible to run wild and add to the concept too.
1) expand to other report grouping sections
2) other interesting things you might want to look at ave, stdv, fun with format count property.

For what it is worth, I think the power of the reporting tool is often over looked for a more complex query based solution.