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

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
 
A

Al Camp

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
Main Report Header is on SubReport 4
Can a Subreport print it's textboxes on the Main report? 3
SUM data from subreport onto main report 7
Using Subreport Total in Main Report 2
Errors in Report total fields 19
subreport totals on Main report 3
Subreport Total on Main Report 3

Top