Full Version: Report Footer - Sum Problem
Rainman
In the report I have a sub-grouping total based off a conditional test.
[Text91]
The control source for Text91 is =IIF(Sum([AmtDue])>10, Sum([AmtDue]),0)

The Text91 sub-total is working fine and doing exactly what it is supposed. However, I need a "Grand Total" at the bottom (Report Footer).

Right now the Grand Total is [Text104]
The control source is = Sum([Text91])

Which should add up all the individual sub-totals. When I run the report I get a pop-up window asking me to input a value for [Text91]. This error is ocurring at the footer level. How can I get a grand total in the report footer based on the sub-totals contained in the section footers?
Does this sound like what you are trying to do?

Show Totals at Bottom of Report
Rainman
Unfortunately No. The Sum function is in the report footer, not the page footer But thank you.
Rainman
If it helps...lets say [Text91] represents a STATE total.
I want at the bottom of the report a grand total for the UNITED STATES.
How can I do that?
Is it the conditional statement in Text91 that's preventing that text box from being summed in the footer?
If you enter in an unbound Text Box in the Detail Section of the Report =Sum([Text91]) and make this Text Box not visible and name it UnitedStates. Then in the Report Footer if you enter in an unbound Text Box =([UnitedStates]), does it give you the Grand Total you want?
Rainman
Good idea. How would I get [UnitedStates] which we would hide... to = [Text91]?
Would that be an OnFormat Event?
Rainman
Also....for the report footer....don't you mean:

=Sum([UnitedStates])

vs

([UnitedStates])

as you stated?
QUOTE (Rainman @ May 16 2012, 10:44 AM)
Good idea. How would I get [UnitedStates] which we would hide... to = [Text91]?
Would that be an OnFormat Event?

In an unbound Text Box, placed in the Detail section of your Sub Report, make =Sum([Text91]). Then if you look at the Property sheet of this Text Box, under the Format Tab, change the Visible from Yes to No. Then under the All tab, name it UnitedStates.

Then in the Report Footer of the Main Report make it equal to the Text Box like the following:

=YourSubReportName.Report!UnitedStates

Change YourSubReportName to the name of your Sub Report. Do not include the Sum fuction here, because it is already used in the Sub Report.
Rainman
I did read what you said. Both times.
However, it doesn't matter. I tried it it and it doesn't work