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.

Show subsumarry of each record subtotal !

Featured Replies

I would like to do like this

REgion Name Total sale

A

John 20

Paul 10

------

30

I create part like ...

Subsummary by REgion ( leading)

body

Subsumarry by REgion (trailing)

But it only works in Preview mode? ...If I want to do like above in Browse Mode? Do you have any idea how to do it in Browse mode?

Thanks

  • Author

I view as a form on browse mode ..it works ...but view as a list on Browse mode ..it does not work.

But in Preview mode it works? No idea how to fix it if I want to see as a list on Browse mode

thanks

Subsummaries can't be viewed in Browse mode. They are also dependent upon sort order. If the sort order is incorrect, they won't show in Preview mode either. To gain subsummary information in Browse mode, you must use relationships and the Sum() function. This is usually only practical for summarizing by, for example, one company at a time. Subsummaries are really a printed report function.

-bd

I've set up a system based on Captkurt's idea of going into preview mode and copying the preview. The script does this:

# Script PasteReport

-Go to preview mode

- Go to the report layout that has the summary parts

-Go to page based on global field gPage

-copy

-go to browse mode

-go to a layout that has a global container field that covers the whole layout

-paste the picture into the container.

This layout also has two buttons: forward and backward

The forward button executes the following script

Set field gPage = gPage+1

Perform script PasteReport

The backward button executes the following script

Set field gPage = gPage-1

Perform script PasteReport

These allow you to page through the report.

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.