Calculating between Sub-Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that contains 3 sub-reports, each with a number of records
displayed from separate queries. I need to get a row total (i.e the sum of
all the first records of each of the sub-reports in a text box of the main
report, then in another text box a sum of all the second records displayed in
each of the sub-reports, and so on) but do not know how to reference this.

=Reports![Main Report]![SubReport1]![Field].Value + Reports![Main
Report]![SubReport2]![Field].Value + Reports![Main
Report]![SubReport3]![Field].Value

Using the formula above i can get the sum of all the first values, but to
get the sum of the second values, third values, fourth values etc how do i
reference this?

Is this even possible?
 
You will not be able to do this by reading the values of the different rows
of the subreports from the main report.

The best solution might be to create another subreport (in the main report's
Report Footer section?) that summarizes the data in this different way.
 
Back
Top