Combining Calculations from subreport

  • Thread starter Thread starter deiopajw
  • Start date Start date
D

deiopajw

I have a main report: Rpt_Main
I have a subreport nestled in this main report called subrpt_Details

In Rpt_Main there is an unbound text box [Total Sales] with a formula in the
Control Source:
=Sum([SalesPrice]*0.85) in the report footer.

The subreport has an unbound text box [AncTotal] with a formula:
=Sum([AncTotalPrice])

I want to be able to create a seperate field in the Rpt_Main footer that
adds the two field formulas:
ie =Sum([SalesPrice]*0.85)+Sum([AncTotalPrice])
I have tried creating a new query that contains the queries of the 2
respective reports but the figures didn't work out.
any suggestions?
thanks
 
Add a text box to the main report section that contains the subreport. Set
these properties:
Name: txtAncTotalRunSum
Control Source: =subrpt_Details.Report.AncTotal
Running Sum: Over All
Then your main report footer, use:
Control Source: =Sum([SalesPrice]*0.85)+txtAncTotalRunSum
 
Back
Top