In the Filters tab (Figure 4-1), the fields of the table/view chosen in the Data Sources tab can be filtered so that only pertinent entries appear in the table.
Figure 4-1 Filters Tab
4.1 Filter Field Drop-down Menu
The Filter Field drop-down menu is a list of the available fields in the table/view that have been selected or created in the Data Sources tab. Select the fields to filter. If joining tables/view, the title of the table/view that the field is from appears in parentheses next to the name of the field.
Figure 5-2 Field Drop-down Menu
4.1.1 Filter Operator Drop-down Menu and Value(s)
Operator Drop-down Menu and Value(s).
The Filter Operator Drop-down lets you select your operator based on the data type that has been selected in the filter. The filter fields available are only those under the Tables or Views selected in the Data Sources tab.
4.1.2 Operator Categories
4.1.3 Blank and Param Check-boxes
The Blank and Param check-boxes (see image above) allow you to control the filtering behavior in the report viewer. They do not affect the “Preview” tab of the report designer.
Blank Checkbox: To use this, first set a “Filter Field” and then set an “Operator.”
If “Blank” is checked, the filter will return data which matches the “Value(s)” drop-down/text-box and also data which has a blank/null value in that field .
In the example above, if “Blank” is checked and then viewed in the report viewer, then the user would see all of the data where the “ShipCity” begins with “s” and all of the “Address” records which are blank or null.
Param Checkbox: To use this, first set a “Filter Field”, set an “Operator”, and then set “Value(s)”, as in the previous example. This will display the filtered report in the report viewer and allow the user to change the filter value. If it is not checked, then the filter will not be visible to the end-user and the end-user will not be able to change the filter.
The example above shows a filter which will display a report in the report viewer where only the Address fields which begin with “s” will be shown. However, a user will be able to change the “s” to a “t” and update the report if desired.
4.1.4 Other Buttons on the Filters Tab
4.1.5 Other Filter Features
Require Parameters in Viewer
The example below requires the user to select at least two parameters before the report will run in the Report Viewer.
Require The First Two Parameters in Viewer