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.

Multiple Sub-Summary Parts

Featured Replies

I'm printing a report with Sub-Summary parts in the layout. I would like to have a summary of the subsummary parts, the same way a trailing grand summary would work except multiple occurances on a page.

Example:

Office Supplies 25.00

Internet Provider 50.00

Phone 30.00

TOTAL EXPENSES 105.00

Sales 200.00

Subscriptions 75.00

TOTAL INCOME 275.00

I suppose I could use a Trailing Grand summary and print each one on a seperate page, but is there a way to do this all on one page?

Have you tried a trailing subsummary part rather than a leading? This trailing subsummary part will have to be sorted by a field that has the same value on all the records you want to summarize. For instance, it looks like in your example you have expenses and sales. Add a trailing subsummary part sorted by this field.

  • Author

Do you mean a sub-summary part that appears above rather than below the records that it summarizes?

I guess my example was a little vague... I am trying to replicate a summary report similar to one in quickbooks.

it would actually be something like this:

software 50.00 (a summary)

pencils 10.00 (a summary)

TOTAL OFFICE SUPPLIES 60.00 (a sub-summary )

phone 50.00 (a summary)

cell phone 50.00 (a summary)

TOTAL PHONE 100.00 (a sub-summary )

TOTAL EXPENSES 160.00 (a sub-summary of a sub-summary)

Sales 150.00 (a summary )

Subscriptions 15.00 (a summary )

TOTAL INCOME 165.00 (a sub-summary )

NET PROFIT 5.00 (a sub-summary of a sub-summary)

I might be able to do it with multiple portals on a layout?

The problem with using portals is it makes the report less flexible. Relationships disregard found sets so you have to build everything into the relationship. With a subsummary report, you can change the report with a simple find.

Anyhow, I decided the best way to show how to do what you want is to create an example file.

SSREPORT.fp7.zip

  • Author

Mark,that it so slick! Thanks for taking the time to make that great file.

There is no way I would have gotten that without the file. I didn't even know you could have a layout without a "body" part.

I use your Scriptology book as well.

Thanks!

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.