Report with 4 subforms - need grand total

[JulieAnnL]

I have a report with 4 subforms (one for each category). The category totals are in the subform, category footer. I need to add all these totals together for a grand total, but nothing I try works.

 

[CosmoKramer]

Check out the section titled "Displaying a Total for All Subreports" in this MS Knowledge base article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;129721

Let me know if this helps....

 

[JulieAnnL]

Thanks for your help! I read the article you referenced and I must be missing something. In the sample, it only uses one subreport. I don't see where it explains how to add the totals for more than one subreport.

 

[CosmoKramer]

I see what you mean. Maybe you should follow the instructions in the other section: Displaying the Total from a Subreport on a Main Report. See #8, add an invisible text box under each subreport that will hold each subreport's total, then sum those 4 invisible text boxes together in another text box to get your grand total.....

 

[JulieAnnL]

I already did this step (#8). It worked great. Where my problem lies in in creating the text box that adds the totals together. I keep getting the parameter boxes. I think this means my expression is not correct. I tried: =Sum(([Category 1 Total])+([Category 2 Total])+(Category 3 Total)+(Category 4 total])) and the same expression with =Val, blah, blah. This didn't work.

 

[CosmoKramer]

This should work, provided these are the names of the invisible text boxes:

=[Category 1 Total]+[Category 2 Total]+[Category 3 Total]+[Category 4 Total]

I don't know if it was a typo or not, but some brackets were missing......

 

[JulieAnnL]

HEY! It worked this time. My report is complete. THANKS SO MUCH!!