totals of subreport

M

Michel Peeters

I have a mainreport with 2 subreports.

The subreports are based on a Totalquery.
In the detailsection from each subreport I have a txtbox named "txtPcs" -
recordsource "= [SumOfPcs]"
In the reportfooter (visible = no) I have a txtbox named : "txtSumPcs" -
recordsource "=Sum([SumOfPcs])"
When I open the subreport without the mainreport this grandtotal works ok.

I want in the mainreport the total from the subreportfooter and I created a
txtbox in the reportfooter from the mainreport with controlsource:
= rptSubreport.Report!txtSumPcs.
But what I get is the [SumOfPcs] from the last record from the subreport.

I tried with running sum but could not solve the problem.
Pse help.

Michel
 

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

column view in reportfooter subreport 3
Hide Subreport on No Data 8
Printing Main Report Details on all pages 2
Hiding Subreports in Mainreport via Form 2
No Record in Subreport 1
Get informations from mainreport on opening subreport 1
How to address subreports properties from main report 1
count in parent report footer 2

Top