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.

Non repeating headers

cj247
in Calculation Engine (Define Fields)

Featured Replies

It seems so easy...

I have a list of theaters, each of these theaters is in a district ("downtown," "suburbs", "northeast," etc.). I want to export a list of these theaters and showtimes with the district header, but only if the header is necessary (I dont want the header to repeat).

i.e. this is right:

DOWNTOWN

theater 1 movies info etc.

theater 2 movies info etc.

theater 3 movies info etc.

SUBURBS

theater 1 movies info etc.

theater 2 movies info etc.

theater 3 movies info etc.

this is NOT:

DOWNTOWN

theater 1 movies info etc.

DOWNTOWN

theater 2 movies info etc.

DOWNTOWN

theater 3 movies info etc.

SUBURBS

theater 1 movies info etc.

SUBURBS

theater 2 movies info etc.

SUBURBS

theater 3 movies info etc.

I thought that maybe I could accomplish this by making a calc field that contains the previous record's "district" field. But I'm having no luck accomplishing this. Is there a way to access this info in a calc field?

Alternately, can anyone see a more elegant way to accomplish this?

Thanks so much for the help...

You can do this with sub-summary parts if you only need it for preview or print, like for a report.

  • Author

I'll monkey around with them, but I need to export this data for printing, not actually print it. Is there a way to get this into an export?

cj247 said:

I need to export this data for printing, not actually print it.

Do you mean export as tab-separated text or print to PDF?

  • Author

Export as tab separated text.

I think the closest you can get with a regular export is to choose Theater and Movie to Summarize by, in the Export dialog.

Another way would be to append field data to a global text field in a format that works, then copy or export that.

Create an account or sign in to comment

https://fmforums.com/topic/22201-non-repeating-headers/
Go to topic listing

Important Information

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

I accept

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.