Alternatives to a sliding footer?

August 16, 200322 yr

Newbies

So here's a question i can't seem to find an answer to after a cursory search.

I have a join table that i'm using to print a list of results, it consists of a body with the records, and a footer with a couple summary fields of the data on that page (total wages paid, etc). Now this all works great, except on the last page of any printout, there's this huge gap between the last record and the footer.

Now, i know i can't have the footer slide up to meet the last record...but is there any other way to achieve the same effect? It really would make the output much more attractive.

I'm using FM 6.0 for Mac.

Thanks in advance!

Octavian

August 17, 200322 yr

What you want to appear would work as a Trailing Grand Summary part. The trouble is that the Footer would also appear. One way to "hide" it is to cover it with a calculated container field that is only filled on the last page of the report.

You need a couple global fields first: _gPageNum (number) and _gBlankContainer (container).

Paste a white square in _gBlankContainer, and set Format, Graphic Options to reduce/enlarge, no proportion.

Create a calculation field: _cgBlankContainer, =

Case (_gPageNum = Status(CurrentPageNumber), _gBlankContainer, "")

Place this field over the fields of the Footer. Field Format to "no entry."

Also set Graphic Options to reduce/enlarge, no proportion.

The printing script needs these additional steps.

Go To Layout ["Print layout"]

Enter Preview Mode [] <-- no pause

Go To Record/Request/Page ["Last"]

Set Field ["_gPageNum", "Status(CurrentPageNumber)"]

Go To Record/Request/Page ["First"]