×
Menu

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
 
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)