Excel Reports: Set up additional data filters when you run an existing report


You can now add in Event Field filters when you run an existing Excel Report.


Tick on the "Advanced Configuration" button and then you will be able to add in a filter for the Event Form/s.

1: Click on the Advanced Configuration tick box

2: All of the Event Form used to create the Excel Report will appear for selection (the example here shows three beacuse this report was set up using three forms)

-Click on the "Add" button to add in an Event Form Filter

The example here shows that a filter is being set up for the Event Form Daily Monitoring and the Field "Hours Slept".

#1: Select the Event Field: e.g. Hours Slept

#2: Select the Condition: e.g. Greater than or equal to

#3: Select the Search Term: 7 (e.g. 7 hours or more)

When you have set up the appropriate filters, Run the Report


Open the file and you will see that ONLY entries that match the filter criteria will be included in the Excel Report



Add your comment

E-Mail me when someone replies to this comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.