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.

summarizing information across several tables

Lougee
in Layouts

Featured Replies

So, if I can't subsummarize a report based on a related field, how do I do show summarized information from several tables?

I need to show information about the current school year (table = activeYear which is the base table for my report layout). How do I summarize students and teachers by memberCode (table: activeYear),by school district (table: districts), by school level (table: schools), by school (table: schools), by ethnicity and by gender (table for both: persons)?

I know this is a very bare bones description of my problem, but I'm better at answering questions that at anticipating them.

Abbe

You can subsummarize a report by related fields. It is the GetSummary function that will not break by related fields, not a summary report.

-Raz

  • Author

I see what I did wrong. I was using summary fields (TOTAL_male and TOTAL_female) from the PERSONS table, not from the ACTIVEYEARS table.

But doesn't this defeat the purpose of a relational db? If I have to have the same fields in more than one table?

Create an account or sign in to comment

https://fmforums.com/topic/44196-summarizing-information-across-several-tables/
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.