Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Total Pages for a Report

Featured Replies

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.

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.

  • Author

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.

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 []

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.