Report/SubRpt totals

  • Thread starter Thread starter Junior
  • Start date Start date
J

Junior

Have a Parent report with an embedded subreport
Parent report is sorted by CeilingGroup and then Service
Service data is in the Service Header
CeilingGroup is subtotaled in the CeilingGroup Footer
and the Grand total is summed in the Report Footer

The subreport is in the detail section of the Parent report
linked by ServiceID with a table as the recordsource
the subreport prints a line for each FundCategory within the Service
FundCategorys are A,C,O,T etc.

My problem - I want to sum and print the grand total of each FundCategory in
the
Parent report Footer.
Please someone tell me the steps to accomplish this..thanks
 
You probably have a text box in the Report Footer section of your subreport
to show the total?

Add a text box to the main report's detail section, and give it this
ControlSource:
=IIf([Sub1].[Report].[HasData], Nz([Sub1].[Report].[txtTotal], 0), 0)
where "Sub1" represents the name of the subform control, and "txtTotal"
represents the name of the text box in the subreport.

Set the Format property to Currency
Set the Running Sum property to Over All.
The text box should accumulate the totals from the subreport.

Once you have that working, you can set its Visible property to No if you
desire, and place another text box in the main report's Report Footer
section to display the total.
 
Back
Top