sum in sub report

[Mike Hughes]

I have a report with two sub reports. What I want to do is sum the numbers from each column from each report to get a grand total.
I have attached two pictures which will hopefully help someone understand what I'm trying to do.

 

[vbaInet]

You will need to add the Sum() function in the Report Footer section of each subreport, then on the main report refer to the totals textboxes from earlier. Use the Code Builder to get the correct syntax.

 

[Mike Hughes]

I'll give it a try, thanks.

 

[Mike Hughes]

That didn't work. Could someone look at the attached DB and show me how to get a grand total from the original report and two sub reports. Thanks Mike

 

[vbaInet]

Tell us what errors are you getting? And how you went about setting it up.

 

[Mike Hughes]

REPORT 2
IN THE REPORT FOOTER =sum([OA_CASES]) FOR THE FIRST COLUMN AND EACH OF THE OTHER COLUMNS.

REPORT 3
IN THE REPORT FOOTER =sum([SA_CASES]) FOR THE FIRST COLUMN AND EACH OF THE OTHER COLUMNS.

Then on the report containing all the sub-reports I’m trying to sum each column in the REPORT FOOTER, PA_CASES, OA_CASES & SA_CASES for each of the columns.

For column 1 on the footer of the report (including sub reports) I put something like this:

=sum(=sum[PA_CASES]) + =sum[OA_CASES]) + =SUM([SA_CASES]))
When I try this I get an error on the report in this field

 

[Mike Hughes]

I'll also attache a screen shot of the report (with sub reports) which might give you a better idea of what I'm trying to do. Thanks for any help you could give. Mike

 

[vbaInet]

Looking at your attachment I don't see where you've put the =Sum() in the Report Footer section of the subreport. It needs to be placed there. Then call the txtbox something like txtTotalSA_Cases.

Then in the Footer section of your main report, use the Expression Builder to find the textbox and get the correct reference. Note in this step I didn't mention using Sum().

 

[Mike Hughes]

Can you see me smile? Thanks so much. Mike

 

[vbaInet]

No Mike I can't. But I bet it's a wide smile, something like this -->

 

[Mike Hughes]

Just one more question. See screen shot

Thanks Mike

 

[vbaInet]

They textboxes do not have to be placed in the Report Footer section. They can be placed right after the subreport if the subreport is not placed in the Detail section.

 

[Mike Hughes]

I have the subreports in the Detail section, should they be somewhere else and where?

 

[vbaInet]

In that case the textboxes can only be placed in the Footer section.

The other thing you can do is create a subreport of your subreports and place the textbox just below the newly created subreports in the Detail section.

 

[Mike Hughes]

OK, thanks again and I think I'll keep them where they are. Mike

 

[vbaInet]

No problemo!