Total Pages for a Report

[Kennel]

When generating a multi-page report is there anyway the total number of pages can be displayed in the header. I would like to display this type of information in my header: Page 2 of 54.

[Jacob22x]

Sure. Make a script that does this when you generate the report:

Go to page [Last]

Set Field [globalpagenumber; Get (PageNumber)

Go to page [First]

Make a global field called globalpagenumber (or whatever you'd like) and put it on your report layout. This time every time you create a report the total page number will be correct.

[Kennel]

Thanks. I knew there was a way just couldn't come up with it.

Created a field: globalpagenumber

Placed field in header of report: Page [##] of [globalpagenumber]

Script steps imbedded in an existing script:

Enter Preview Mode [no pause]

Go to Record/Request/Page [Last]

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

Go to Record/Request/Page [First]

continue on with existing script.

Worked like a charm.

Thanks again.

[powerbookstuff]

my experience has been that i need to have a refresh window script step after the set field step and more importantly that i have to perform the steps below twice to get the screen to update properly with mac os 9.2.2 & fm pro 6.0.4.

it appears to be some sort of timing issue with the problem showing up in reports with more than a few pages. i just tried reports with '400' and '800' pages and the duplicate steps are the only way i get the correct total pages.

Go to Record/Request/Page [Last]

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

Refresh Window []

Go to Record/Request/Page [Last]

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

Refresh Window []