page footer calculated field

[Guest]

In a footer section I have a report summary, with total quantities, amounts
etc.
I need this summary to appear always on the page footer.
So, I have moved it from the section footer to the page footer.
The problem is that the calculated fields are no long working on the page
footer.

Is there any way to have this calculated fields working on the page footer?

 

[Rick Brandt]

In a footer section I have a report summary, with total quantities,
amounts etc.
I need this summary to appear always on the page footer.
So, I have moved it from the section footer to the page footer.
The problem is that the calculated fields are no long working on the
page footer.

Is there any way to have this calculated fields working on the page
footer?

Aggregations don't work in the page header/footers. There is a way to work
around that which is explained in a KB article on Microsoft's web site.

 

[Bongard]

In a footer section I have a report summary, with total quantities, amounts
etc.
I need this summary to appear always on the page footer.
So, I have moved it from the section footer to the page footer.
The problem is that the calculated fields are no long working on the page
footer.

Is there any way to have this calculated fields working on the page footer?

Raul I think there is a way to do this. Locate the name of one of your
report footers. Lets just say the name is [TransactionSum]. In the Page
footer insert a text box and make its control source equal to the name
of your report footer for instance:

Control Source =[TransactionSum]

I think that should work.

-Brian

 

[Marshall Barton]

In a footer section I have a report summary, with total quantities, amounts
etc.
I need this summary to appear always on the page footer.
So, I have moved it from the section footer to the page footer.
The problem is that the calculated fields are no long working on the page
footer.

Is there any way to have this calculated fields working on the page footer?

Assuming that your totals are calculated using the Count
and/or Sum functions, place the calculation text boxes in
the Report Header section (can be invisible). Then use text
boxes in the page footer that refer to the report header
text boxes.

 

[Guest]

thank you all.
the hide trick solved the problem

"Raul Sousa" escreveu:

 

[Guest]

MArshall -- I tried adding the =[Commision] text box n the Report Header and
I can only get the value of the first detail to disply in the Page Footer. I
have a Commision text box in my detail and I am trying to get the total of
all of the commision earned to display in the Page Footer. I can get it to
show in the Grouping Footer without a problem, but when I refer to the
Grouping Footer text box my Page Footer total displayes $0.00.

 

[Marshall Barton]

The report header text box must use an aggregate function
(total for entire report). If your situation is the same as
the original question, then the header text box expression
would be =Sum(Commision)
--
Marsh
MVP [MS Access]

MArshall -- I tried adding the =[Commision] text box n the Report Header and
I can only get the value of the first detail to disply in the Page Footer. I
have a Commision text box in my detail and I am trying to get the total of
all of the commision earned to display in the Page Footer. I can get it to
show in the Grouping Footer without a problem, but when I refer to the
Grouping Footer text box my Page Footer total displayes $0.00.

Assuming that your totals are calculated using the Count
and/or Sum functions, place the calculation text boxes in
the Report Header section (can be invisible). Then use text
boxes in the page footer that refer to the report header
text boxes.