Re: Adding two subtotals from two subreports in a main report

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

If both subreports
- are in the same report section and
- will always contain records and
- they have a text box named "txtRptTotal" containg the subtotals
You can create a text box in the main report with a control source like:

=[SWO R].Report!txtRptTotal + [LABOUR R].Report!txtRptTotal

If you don't find success, come back with some real values for us.
--
Duane Hookom
MS Access MVP

"Renee" <Renee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CAB1C48-B8E5-4349-BE26-39118A21AC60@xxxxxxxxxxxxxxxx
I have a report called SWO R that has two subreports in it called LABOUR R
and PARTS R. Both of these subreports have subtotals in them created using
a
text box and I would like to add the two subtotals together in the main
report but I can't seem to get it to work. Does anyone have any ideas of
how
I can do this?


.

Relevant Pages

  • Re: adding subreport values on main report
    ... Miranda wrote: ... >i've got a report with 5 subreports which are arranged according to date. ... >need to add up the subtotals from all of the subreports and put this on the ...
    (microsoft.public.access.reports)
  • adding subreport values on main report
    ... i've got a report with 5 subreports which are arranged according to date. ... need to add up the subtotals from all of the subreports and put this on the ...
    (microsoft.public.access.reports)
  • RE: bind subreports during runtime
    ... Forthermore a lot of plugin-components are exsting. ... of a framework- report. ... I received an exception "Not supported within subreports" ... Eine existierende Framework-Komponente soll Report- Funktionalität anbieten ...
    (microsoft.public.vb.crystal)
  • RE: bind subreports during runtime
    ... Forthermore a lot of plugin-components are exsting. ... of a framework- report. ... I received an exception "Not supported within subreports" ... Eine existierende Framework-Komponente soll Report- Funktionalität anbieten ...
    (microsoft.public.vb.crystal)
  • Re: I need to do some totals of subreports
    ... I'll address your issues in the reverse order: ... To determine your totals, you'll need to restrict the data in the ... your record selection in your main report, ... The more subreports you have, the slower your report will be. ...
    (microsoft.public.vb.crystal)