Having a Group By filter on In Form Reports

The ability to have a Group By Drop down above the table that can filter the In Form Report table based on options for any of the option fields in that table.This allows users to filter all inform reports on the fly without having to set a filter in the Form Builder. You can filter by multiple Group By fields.

Any fields set as "Is a Group" that is included in an In Form Report can be used as a filter in the In Form Report Table

Any fields set as "Is a Group" that is included in an In Form Report can be used as a filter in the In Form Report Table

In a different Event Form, these fields are set to appear in an In Form Report

Any field which is set up as a Group By can be used in the In Form Report as a filter when viewing the data

Any field which is set up as a Group By can be used in the In Form Report as a filter when viewing the data

The filters can be used to limit the records showing in the In Form Report

The filters can be used to limit the records showing in the In Form Report

Complete the filter

Complete the filter

The report will update and only show records matching that search

The report will update and only show records matching that search

Multiple filters can be used to limit the data

Multiple filters can be used to limit the data

When two or more group by field filters are used, this acts as an ALL filter and only records that meet ALL search terms will be shown.

Note that ONLY fields not set as "Group By" will appear as a filter. If it is not set up as a Group By then the field will just appear as part of the table

Note that ONLY fields not set as "Group By" will appear as a filter. If it is not set up as a Group By then the field will just appear as part of the table

Injury Diagrams will appear as per normal. Any Group By fields will also be available for grouping (e.g. Current Status).

Injury Diagrams will appear as per normal. Any Group By fields will also be available for grouping (e.g. Current Status).

If none of the fields selected for use in the In Form Report are set as Group By, then no filters will appear

If none of the fields selected for use in the In Form Report are set as Group By, then no filters will appear

0 Comments

Add your comment

E-Mail me when someone replies to this comment