How do I sum a subreport and put the value in the main report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an invoice report that contains a sub-report listing the booths
purchased. I need to bring the total cost of those booths to the main
report, add it to certain other fees, subtract the payments made, and
generate a balance. The problem is that I can't get the total cost from the
subreport to the main report. Any ideas on how to do this? TNX
 
Amy,
Place an unbound calculated text control in the footer of your
subreport... (use your names)
=Sum(BoothCosts)
and call it BoothCosts.
The main report should be able to refer to that value as...
Reports!rptYourMain!rptYourSub.Report!BoothCost
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions
 
Back
Top