Anyone know how to put the total number of pages in a footer on a report so that it reads:

Page X of Y

(ie. how do you put/calculate "Y"?)

Thanks

FileMaker Version: 5

Platform: Mac OS X Panther

I think I saw a thread on this a week or two ago.

OK... here you go.

First you'll need a global number field to temporarily store the number of pages. This field will be the Y part of the "Page X of Y" merge string. Example: Page ## of <<gPageCount>> where gPageCount is global field name.

Next perform the find, sort and layout script steps necessary for your report.

Now enter Preview Mode and go to the Last page.

And finally set the "gPageCount" field the the Current Page Number.

The script will look something like this depending upon your actual choice and field name, find and sort settings and layout name.

-----------------------------------------------

Perform Find [Restore find requests, Replace Found Set]

Sort [Restore sort order, No dialog]

Go to Layout [Report]

Enter Preview Mode[]

Go to Record/Request/Page [Last]

Set Field [gPageCount, Status(CurrentPageNumber)]

Let me know how this works out... you should do fine.

Works awesome - Thanks!!