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
 

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

Similar Threads

SynNeed to account for null values in subreports 2
Can a Subreport print it's textboxes on the Main report? 3
Main Report Header is on SubReport 4
How do I add amounts from subforms for a totals footer? 2
Using Subreports to create a Main Report 7
Calculate a sum of subreports in main report 1
subreport totals on Main report 3
Calculate between SubReport and Report 1

Back
Top