When a report is generated it can be set up so that the user is asked to select data filters to refine what data is returned within a report.
To set up one or more filter conditions follow the steps below.
- Tick the active box next to the header name on the table's panel on the right hand side of the screen as shown below.
- Repeat for each header that you wish to filter by.
In the worked example for this chapter you may like to add filter conditions for Depth and N value as shown below left. When you generate the report a Filter form will be displayed as shown below right.
To find SPT data for all SPT values less than 30 below 3 metres simply set the filter form as fol-lows.
If you leave the value column blank then the filter on that row will not be applied
Filters can be applied to any heading whether or not it is included in your report output.
Types of Filter
The filter form will change depending on what heading is being filtered:
Location ID
When you select filtering to be active on Location ID the form below is displayed that allows you to select the locations using the tick box to the left hand side of the grid.
This is a power form and has a number of features to allow you to filter your locations.
- The filter icons (funnels) at the top of each column can be used to filter the contents of the grid. More than one column can have formatting applied
- Grids can be ordered by clicking on the grid title once for ascending and twice for descending. More than one column can be ordered by using the shift key while clicking.
- Select All option can be used to select all the records that are currently displayed in the grid.
- The selection can be set to all locations within OpenGround Cloud by selecting the group name from the drop-down list at the base of the form.
Text
When a text field is set for filtering the following options are available. All text filtering is not case sensitive so a search for "CLAY" will return fields that contain "Clay", "clay", "CLAY" etc.
- Contains
- Not contain
- Equal
- Not equal
- Begins With
- Not Begin With
- Ends With
- Not Ends With
Numeric and Date Fields
When a number or date field is set for filtering the following options are available.
- Equals
- Not Equals
- Greater than
- Greater than or Equal
- Less than
- Less than or Equal
Numeric and date filter can be set up to do between two values using the clone filter option.
Pick List
When a pick list field is set for filtering the used pick list items are listed in a form on screen as shown below.
Prefilters
Filter conditions can be set to be run automatically so that the user does not have to keep selecting the same options. When filters are set up this way they are referred to as a prefilter.
A good example of when to use this is if you are generating a report that is only to be used to report data from trial pits. Instead of asking the user to select TP from the Pick List filter each time you can simply set this filter condition to be a Prefilter and set its condition to be TP.
To set a filter condition to be a prefilter condition follow the steps below:-
- Select the filter icon from the Ribbon to display the filter form.
- Click the Prefilter checkbox next to the filter and click OK.
Before you save the report you must generate the report so that a filter condition can be saved. The report will save the last used filter condition before the report is saved.
When generating a report in design mode the prefilters will not be active enabling you to set them up. To test a prefilter save the report to a project or configuration pack and run it in nor-mal mode.
Cloning filters
Text, number and date filters can be cloned to allow you to define a between value or more than one text string query. Examples of how this could be used are shown below:
SPT data between 3 and 5m
Locations created in a set week
Descriptions that contain the word Clay and Peat
To create a cloned filter follow the steps below
- Select the filter icon from the Ribbon to display the filter form.
- Click the filter Condition and click the Clone button. The filter will now appear in the list twice.
Select it from the filter form and press the delete key on your keyboard to delete it.