You can use the Filter option to restrict the number of displayed records.
With the Column filter type selected, you can create a filter for a particular column (field). The Filter dialog box is shown below.
Select the column in which you want to search in the Column drop-down list, and select the operator to be used for the search from the Operator drop-down list. The picture below shows the available operators.
Together with like and not like you can use the wildcards % (any string) and _ (any character) in the Expression field.
In the Expression field, enter a search criterion to be used to filter the data. For example, you could enter a string like R% to find all values starting with R. You can also open the list, and then select a value.
Finally, click Apply to apply the search filter.
With the Row filter type selected, you can create a filter for multiple fields. The Filter dialog box layout changes.
-
Enter a name for the filter in the Name field.
-
Select a column from the list in the Columns field.
The leading character is inserted in the Filter Expression field.
-
Select an operator or function from the list in the Functions/Operators field.
-
Enter a value that should be used to filter the column.
-
Combine multiple columns using AND or OR.
-
Click Apply to apply the named filter.
You can define and enable multiple filters for a report. Only data that matches all enabled filters appears in the report. The defined filters appear at the top of the flat lists as shown in the picture below.
To edit a filter, click the filter name to open the Filter box. Clear the check box to disable the filter. Click the x to remove the filter.