Sub Report Controls

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
 
D

Damon Heron

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top