Adding values from multiple sub-reports

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

Guest

I have 3 subreports, each with around 9 records displayed. I want to add the
first values in all three of the sub-reports (to get a row total count).
This works fine with referring to each of the sub-reports with:
=Reports![Main Report]![Sub Report1].Value+Reports![Main Report]![Sub
Report2].Value + Reports![Main Report]![Sub Report3].Value

But that only looks after the first row by getting the first value. When it
comes to adding the second value in each of the sub-reports, I do not know if
it is possible. How do you (if you can) reference the second record
displayed in a subreport from the Main report?
 
BECAM said:
I have 3 subreports, each with around 9 records displayed. I want to add the
first values in all three of the sub-reports (to get a row total count).
This works fine with referring to each of the sub-reports with:
=Reports![Main Report]![Sub Report1].Value+Reports![Main Report]![Sub
Report2].Value + Reports![Main Report]![Sub Report3].Value

But that only looks after the first row by getting the first value. When it
comes to adding the second value in each of the sub-reports, I do not know if
it is possible. How do you (if you can) reference the second record
displayed in a subreport from the Main report?
Click to expand...


Not possible. There is no way to identify an individual
record (or group) in a subreport.

You should find a way to get the value from each recod in
the three tables in a query and then use another subreport
to diplay them. Hopefully you have a field that can be used
to correctly join the appropriate records in the tables.
 
Back
Top