Grand Total that included subreports

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SynNeed to account for null values in subreports 2
Help With Grand Total for Subreports 16
subreport/report total question 5
One and One-half Columns and Grand Total on Same Page (?) 3
Totaling Multiple Subreports 5
Sum 2 subreports total in a main report 3
Using Subreports to create a Main Report 7
Report with multiple subreports 3

Top