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

Unfortunately No. The Sum function is in the report footer, not the page footer But thank you.

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?

Good idea. How would I get [UnitedStates] which we would hide... to = [Text91]?
Would that be an OnFormat Event?

Also....for the report footer....don't you mean:

=Sum([UnitedStates])

vs

([UnitedStates])

as you stated?

Read what I said before please.

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.

I did read what you said. Both times.
However, it doesn't matter. I tried it it and it doesn't work

Then upload a zipped copy of your dbase, with no private data and I will take a look.

Rainman,

Is this a Main Report and a Sub Report that you are working with? If so, are you placing the Sub Report in the Detail Section of the Main Report? If so, if you click on the outside of the Sub Report and view the Property Sheet, click on the Data Tab is there anythin in the Link Masters Fields and the Link Child Fields and is the info correct? What, if anything, are you getting as the Grand Total? Thanks!

RAZMaddaz

The sub report is in the sub-footer section, not the detail section.