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.

Report Formatting

Featured Replies

I've recently learned how to use summary fields and subsumary parts.

My issue is i'm attempting to create a report that groups vertically rather than horizontally.

For example I need a report for widgest sold that groups all the months in one report and the months are the column headers.

For example

[April][May][June]

[widget1][#April][#May][#June]

[widget2][#April][#May][#June]

[widget3][#April][#May][#June]

[TotalApril][TotalMay][TotalJune]

hopefully that illustration explained my point..

I have no issues grouping by widget names, types, etc.. but I can't figure out how to count within the certain months. My find request would either be for a specific date range (1 date range) rather than multiple but I need results from multiple finds.

Any suggestions? This seems to be a simple reporting concept so i'm sure there's a simple way to do it that i'm missing.

Please help!

This is not a simple reporting issue. This type of report is referred to as a cross-tab, and is very difficult to achieve in FileMaker.

Here is a link to a very popular technique, but it certainly isn't beginner-level stuff. M. Edoshin's Cross-tab article

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

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.