Trouble with Grand Total sums on Report

[mmadani]

I have a report that has subtotals, and exceptions, that assigns values to
controls on the report.

I get a parameter box every time I try to introduce a new variable to sum
the subtotals in a grand total footer.

I have done this many times, but right now, I can't remember.

Any ideas.

Thanks

 

[Steve Schapel]

Mmadani,

It's difficult to know what you mean... could you give an example?

 

[mmadani]

The same formulas are used in the subtotals, and Grandtotals always will
produce an overall sum of the values in the report.
If I add a new variable that performs calculations in the report footer, it
comes back with an error of not recognizing the query defined variables (or
table objects)


Example:

detail section
variable=([ActEquips])

Detail footer
variable=Sum([ActEquips])

Report Footer
variable=Sum([ActEquips])
if I add new variable=Sum([ActEquips]) , it comes back with a parameter box
asking for a value of ActEquips

 

[Steve Schapel]

Mmadani,

In the Detail section, you have a control bound to the ActEquips field,
right? And in a Group Footer, you have a control with Control Source
set to =Sum([ActEquips]), and this behaves as expected and shows the
correct value... right? And then in the Report Footer, you have
another control with Control Source set to =Sum([ActEquips]), but this
one does not work, but prompts you for the value of ActEquips? This is
most peculiar behaviour, and I can't think of any reason except...
1. mis-spelling of ActEquips in the control source setting
2. the control itself where you are entering the =Sum([ActEquips])
expression is itself named ActEquips

When you open the report, how do you know which control is responsible
for the triggering of the parameter prompt? Do you mean that if the Sum
control is removed from the Report Footer, it works ok, but when you add
the Sum control to the Report Footer, this is when the problem arises?

 

[AccessUser]

Yes Steve;

Exactly! and I have copied and pasted to avoid miss-spelling errors or
spaces etc.. The control name is not the same. I tried adding a text box
Text181= Sum([ActEquips]), same result. either it asks for a value or no
error brings back a blank value.

I know.. this is really funny. and I even repaired office installation, to
rule out funny stuff.

Thanks

Mmadani,

In the Detail section, you have a control bound to the ActEquips field,
right? And in a Group Footer, you have a control with Control Source
set to =Sum([ActEquips]), and this behaves as expected and shows the
correct value... right? And then in the Report Footer, you have
another control with Control Source set to =Sum([ActEquips]), but this
one does not work, but prompts you for the value of ActEquips? This is
most peculiar behaviour, and I can't think of any reason except...
1. mis-spelling of ActEquips in the control source setting
2. the control itself where you are entering the =Sum([ActEquips])
expression is itself named ActEquips

When you open the report, how do you know which control is responsible
for the triggering of the parameter prompt? Do you mean that if the Sum
control is removed from the Report Footer, it works ok, but when you add
the Sum control to the Report Footer, this is when the problem arises?

--
Steve Schapel, Microsoft Access MVP

The same formulas are used in the subtotals, and Grandtotals always will
produce an overall sum of the values in the report.
If I add a new variable that performs calculations in the report footer, it
comes back with an error of not recognizing the query defined variables (or
table objects)


Example:

detail section
variable=([ActEquips])

Detail footer
variable=Sum([ActEquips])

Report Footer
variable=Sum([ActEquips])
if I add new variable=Sum([ActEquips]) , it comes back with a parameter box
asking for a value of ActEquips