Filtering a View or a Report
All reports within Bp Allied can be filtered and grouped which provides you with a more powerful reporting tool. This section covers how to use the Filtering function.
Filtering allows the results of a report or a view to be changed so that only some records can be seen based on a specific criteria. For example, in the Item Sales Report you may wish to see the report based on a specific Item such as Iniital Consultation.
Finding the filter options
The column heading in all reports and a number of views is usually where the filtering functions hide. Hovering over a heading will display a small push pin that if clicked on will display filtering options.
OR
Right Click
Select Filter Editior
OR
Click on the Show/Hide Autofilter Row (This is available on all Reports)
Use an * as a wildcard to filter on part of a description in the filter row.
OR
Click Show Filter Row (This is available on all tables in Data Maintenance)
An example using a filter in the Item Sales Report
Open the Item Sales Report
Enter in a date range
Click Go
Hover over the column to filter by, in this case, Category
Click on the push pin
A drop down list will display with all of the available values in that column as well as several special options
-
Blanks - will show all records missing a value
-
Non-Blanks - will show all records which have a value in this field
-
Checked - displays for tick box fields
-
Unchecked - displays for tick box fields
-
Custom - this can be used to create an AND or OR scenario
For this example select Custom
The Custom Auto Filter box displays
Enter in the values as below so that it is filtering for Category = MP Data OR category = MP SA (these values need to be entered in exactly)
Click OK
The Item Sales Report filtered for MP Data or MP SA results display as follows:
The filters that have been applied display at the bottom of the results pane
Filters can be applied to more than one column at a time
In this example, an additional filter is applied to the Location field. Location = MP NZ Headquarters
The applied filters
If you want to get more complicated
Right-click on the Column Header
Select Filter Editor
OR
Click Edit Filter from the filter display at the bottom of the results pane
The Filter Editior displays
Click the + to add further filters to your report.
Click on the Field names (in blue) and the qualifiers (in green) to change the values in the editor.
To remove a filter
From the Filter Editior click the grey X
OR
Click the X on the left of the filter display
OR
Click on the Push Pin
Click (All)
