Adding values from multiple sub-reports

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

Marshall Barton

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?


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.
 

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

Top