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.

Summary fields in sub summary part

  •
NewFM85User
in Finding & Searching

Featured Replies

Hi,

I have 2 tables. Orders table and Template table. Orders are created every issue from template table.

But the customers can modify the order for that issue. Both these tables are related by issue ID.

I want to create the the report to campare the total count of actual order of booklets every issue Vs the count of booklets customers are supposed to order.

When I place the summary fields from both the tables in sub summary part on the report, it shows the total for just one table, the other subtotal is the total of last order.

How can I get the subtotals of both the fields?

Please advise.

Thanks for your help.

These parts are not clear:

Orders are created every issue from template table.

What does a record in the Template table represent?

Both these tables are related by issue ID.

Is there a table of Issues?

the count of booklets customers are supposed to order.

Which would be where?

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.