Report footer

[Guest]

I have a problem with my report footer, when the report consist of more than one page I dont get the footer to stay on the bottom of the page.
I have tried to use the page footer but then I get the text on every page not only the last one which I what
Anybody with a good tip on how to solve my problem??

 

[Allen Browne]

You need to restrict the data so the report contains only the record(s) you
want.

A simple way to do that is to use the OpenReport action in a macro, and use
the WhereCondition to restrict the report. For example, if you only want the
records where CategoryID is 12, put this for the WhereCondition (lower pane)
in your macro:
[CategoryID] = 12

Another alternative is to do this in the query, in the Criteria row.

Naturally enough, the Report Footer section appears only at the end of the
report, so the idea is to restrict the report to only the records you want.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a problem with my report footer, when the report consist of more

than one page I dont get the footer to stay on the bottom of the page.

I have tried to use the page footer but then I get the text on every page

not only the last one which I what.