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.
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.
The filter form will change depending on what heading is being filtered:
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.
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.
When a number or date field is set for filtering the following options are available.
Numeric and date filter can be set up to do between two values using the clone filter option.
When a pick list field is set for filtering the used pick list items are listed in a form on screen as shown below.
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:-
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.
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 it from the filter form and press the delete key on your keyboard to delete it.