Grand Total that included subreports

T

T-bird

I have a report with 4 subreports. I have them all listed within the detail
section of the main report. In the Report footer section of the main report I
would like to add a text box that calculates a "Grand Total" of the the main
report with the 4 subreports. Each report has a text box that calculates
"=Sum([Lost Savings]). The name "Total Lost Savings" is the name for each
text box of each report. All reports are based on a table called "Travelocity
Air Travel Data". PLEASE HELP ME!
 
A

Allen Browne

This article explains how to get the total onto the main report:
Bringing the total from a subreport onto a main report
at:
http://allenbrowne.com/casu-18.html

Be sure to put this text box in the same section as the subreport. You can
then use the Running Sum property of the text box to accumulate the total
over the whole report.
 
Top