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.

Creating a Filtered Summary Report

Jed69
in Layouts

Featured Replies

I have a summary report which works fine. It shows actions taken, grouped by staff and the specific action, and then it counts the number of actions. Each action has a date and I want to be able to filter the results if they fall between set dates. The dates which form the criteria for the report are entered in a custom dialogue box and become variables in the script. I have used these dates to give either a Yes or No result in a filed in the relevant table, the idea being to run the filter if the field says yes. So far so good, all works, but when I put the filter into the script the report does not run properly. Does anyone have any ideas? Picture of script attached

Picture_3.png

Why don't you use the entered dates to find the records to report?

  • Author

Ok would love to but can not work out how to do it. The find will not let me put in the variables as a filter parameter. Can you tell me how I would do it?

You cannot use dynamic criteria in a stored request. You need to do it this way:

...

Enter Find Mode []

Set Field [ Date ; $startDate & ".." & $endDate ]

Perform Find []

...

Note that Enter Find Mode [] and Perform Find [] have no selected options.

  • Author

OK thank you. That filter works and seems to have solved the other problem as well. Many thanks again

Create an account or sign in to comment

https://fmforums.com/topic/60385-creating-a-filtered-summary-report/
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.