dynamictiger
Technical User
I have a main report with lots of subreports. I need to total the sub reports to give me a total for all sub reports???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I give up - How do you total for sub reports 1
- Thread starter dynamictiger
- Start date
- Status
-
1
- #2
I believe you have a limited number of subreports.
Create a textbox in the main form:
=[SubForm1].[Report]![TotalField] + [SubForm2].[Report]![TotalField]+[SubForm3].[Report]![TotalField]
where SubForm1,2,3 and so on are the names of the subreports and TotalField is the name of the Total textbox on each subreport.
It should work...
![[pipe]](/data/assets/smilies/pipe.gif "[pipe] [pipe]")
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
Create a textbox in the main form:
=[SubForm1].[Report]![TotalField] + [SubForm2].[Report]![TotalField]+[SubForm3].[Report]![TotalField]
where SubForm1,2,3 and so on are the names of the subreports and TotalField is the name of the Total textbox on each subreport.
It should work...
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
- Status
Similar threads
- Locked
- Question