To open the Drillthrough filter - design dialog, do one of the following:
Click Table options and select Filter.- Select View menu> Table options> Filter.
To open the Drillthrough filter - design dialog, do one of the following:
|
Filters enable you to limit the data that appears in a drillthrough.
To create filters, first choose a field from the Field drop-down menu. Then choose an Operator and type a Value.
The following operators are provided:
= |
Equals |
<> |
Does not equal |
< |
Is less than |
<= |
Is less than or equal to |
> |
Is greater than |
>= |
Is greater than or equal to |
Contains |
(For text fields only) |
Starts with |
(For text fields only) |
Click OK to apply the filter, Cancel to return to the drillthrough page, or Clear to clear all the fields and start over.