Calculating between Sub-Reports

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?
 
A

Allen Browne

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.
 

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

Report Totals on Text Boxes in Sub Report 2
Counting and totaling from a subreport 6
Adding values from multiple sub-reports 1
Blank page between two sub reports 1
Page break between sub reports of a sub report 1
sub-reports page numbering 2
Filtering subreports on main report 0
Can sub-report parameters vary by main report values per page? 3

Top