Totaling subreports in a report

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

Guest

I am working on a report that contains two subreports. Each subreport has a
list of numbers and then calculates a total. I am wanting to take the two
totals from the separate subreports and make a grand total at the bottom of
the report. Anytime I try to do it, it only pulls the first number of each
subreport, not the totals.
 
You should include a sum in the subreport report footer. Add a control to
the main report that references this report total from the subreport.
 
I already have the totals in the footers of the subreport. The totals are
text18 in subreport1 and text16 in subreport2. When I try to pull from those
boxes, I am still only getting the first number in the detail list. Could you
give me an example of a control I could usein the main report? Thank you.
 
Make sure the control is in the subreport footer and name it something that
makes sense like "txtSumHours". You should then be able to add a text box to
the main report like:
=subreportControl.Report.txtSumHours
 
Back
Top