Report Footer Error#

[casey]

I'm trying to list totals on the page footer of a report, but they display an Error#. If I move the totals to a different section of the report, they seem to work fine, but I would prefer to have them on the page footer section. Does anyone know what am I doing wrong?

 

[Rich@ITTC]

Hi Casey

You have almost answered your own question. You have found that the totals work in other sections of your report and that is the answer.

Usually the total would be expected at the end of the report, so most of the time this is where calculated fields are put - in the Report Footer. Another possibility is in a Group Footer giving the totals relating to a particular group of fields (this may go over more than one page in some circumstances).

Page Footers don't work with totals - what would they be totalling? The records on that particular page, the records on that and previous pages, all the records on the report?

I think you have to use one of the two other alternatives - Report Footer or Group Footer.

HTH

Rich Gorvin

 

[Rich]

This article will show you how to add totals to page footer.
Article ID: Q132017

 

[casey]

Thanks for the help, guys. It makes sense that the totals would go at the end of the report. However, I have trouble getting the spacing right. I want them to show up at the bottom of the page(where they look much better). The totals either get bunched up under the detail section or end up on empty page when I put them in the report footer. Do you know how to get them to show up at the end of the page on the bottom?

[This message has been edited by casey (edited 04-02-2001).]