Hello-

In the footer of my reports, I would like to display: Page No. "X" of "Y" where X is the current page and Y is the number of total pages.

I have used "Insert Page Number Symbol" for the "X" value, but how can I display the TOTAL number of pages?

Any ideas?

Thank you in advance- you all have been great...

One way, which may not be the optimized FMP7 way, is to...

1. Define a global number field called "TotalPages"

2. In your footer, add "## of <<TotalPages>>"

3. Then write a script that does something like...

Enter Preview Mode

Go to Record [Last]

Set Field [TotalPages; Get(CurrentPage)]

If your layout printed one record per page (no more, no less) you might be able to get away with using Get(FoundCount) as the "Y" part of the page count in your footer instead of the global field and the script. See which one works best.

SR

This function should be built into FileMaker Pro. Competing products have it built-in (eg. Access, Excel, Word to name a few).

FileMaker users will have to remember to add this script to every database they create, if they want the Page x of y functionality. It's a very nice (& useful) feature on reports.

Juat one thing about the script for fp7: the Get function CurrentPage is now PageNumber.