Sub Report Controls

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

How do you sum up calculated controls on a sub report to total up on a
main report? I have 3 Sub reports that I have to subtract and add at on
the Report footer and I don't know how to refer to the sub report controls
Thanks
DS
 
Here is a sample from one of mine. This is used as an expression in a
report to give the on hand beginning qty (from subreport) and total activity
during the month to give on hand end of period.


=[name of subreport].Report!SumofUnits+[Sum Of UnitsReceived]-[Sum Of
UnitsRemoved]

HTH
Damon
 
Back
Top