Totaling subreports in a report

E

Echo

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.
 
D

Duane Hookom

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.
 
E

Echo

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.
 
D

Duane Hookom

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
 
Top