Filtering Table Report Data
You can set filters on columns in a table report to filter the data displayed. Table section filters are applied in addition to the filters set in the Results section. Filters set in the Table section are automatically propagated to the other reports that inherit their data set from the Table. You can always suspend or delete filters to return data to the display and make it available for reporting.
The Status bar displays the total number of rows in the table report. You can apply one filter only per column.
To filter data in a Table report:
Double-click the column in which to place a filter.
The Filter dialog box is displayed.
Select a logical operator from the shortcut list.
Complete a filter definition by supplying constraining values.
Create a Customs Values list by supplying a value (or values, separated by commas) in the Edit field, and clicking the check mark.
You can also click Show Values to display column values and select one or more values depending on the comparison operator.
When the values are highlighted in the values pane, click OK.
The filter is applied to the column and the column name is added to the Filter line.
To remove a filter in a Table report, select the filter item that you want to remove, and choose Remove on the shortcut menu.
To remove all filters in a Table report, select Filter on the Filter line and choose Remove on the shortcut men.