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.

complex reporting using FM7 new features

Featured Replies

This is for a db that is used to record individual daily receipts, called receiptsdb.

I have a detail/sub-summary report created in FM5-6 which required the following:

1. A Find of all receiptsdb records in a selected fiscal year (prior to) the currently-selected month;

2. A Sort of this found set, then an Export (FM) of the receiptsdb amount data summarized in 3 ways-to a file called priormonthtemp1;

3. Then an Import of this exported/summarized data into another existing (temporary use) FM file-called priormonthtemp2.

3. Then a new Find in receiptsdb for only the records in the currently-selected month and fiscal year;

4. A Sort of this new found set, then a display of the detailed records for the currently-selected month, along with a sub-summary display of the summarized amounts from priormonthtemp2.

So...for each category of receipts in receiptsdb, the report displays the sorted detail records for the currently-selected month, then a total of that same category for all months in the fiscal year prior to this month, then a grand total of receipts year to date.

I am testing whether the new features in FM7 (multiple found sets, table occurences, etc.) would allow me to produce this same report WITHOUT going through this complicated Export/Import/display scenario, with no luck so far.

Any suggestions would be greatly appreciated. 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.