Totals from subreports showing up incorrectly in main report

R

Rahul Prabhu

I am running into a very weird situation. I am trying to pass totals
calculated in the subreport's report footer area to main report. The
problem is the values passed to the main report are incorrect. I tried
everything described in various forums but the problem persists.

Just for the sake of trying different things, I tried selecting the
option - Force New Page before section for the subreport's report
footer and it turns out that in this case the values are passed
correctly. No clue why, but whenever I have the subreport's report
footer displayed right after the subreport's data (not on a different
page), the values turn out to be incorrect.

Any clue why this might be happening. I am so frustrated :(

Thank you so much!
 
D

Duane Hookom

What is the control source of the text box in the main report? I would expect
something like:
=subrptCtlName.Report.txtTotalFromSubreport
 

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

to show subreport's page footer in main report 1
Changing subreport orientation in main report? 3
Can a Subreport print it's textboxes on the Main report? 3
Subreport page break in label controls or textbox controls 6
Report with 2 Subreports 1
Showing Totals from Subreport on Main Report 5
Problem getting value in a subreport displayed in main report correctly 3
Sum 2 subreports total in a main report 3

Top