You can apply operators to your report data so that you either filter or highlight data based on criteria you define. You can apply multiple filters to a report and you can apply filters to filtered data. If your active dashboards contain multiple reports, you can apply a global filter to all reports. A global filter is a filter that is applied to reports that contain the column you are filtering on.
Operators include:
The Filters Selection dialog box opens. You can change the operation after you select it.
Values are entered, either by typing a value in a text box, or selecting a value from a drop-down list.
If you are adding additional filters, you can apply either AND or OR logic. AND logic considers all filters and all data must pass all filters in order to be included in the report output. OR logic considers filters independently and includes data that meets any of the applied filters in the report output.
Once you apply a filter or highlight, and minimize the selection dialog box, the selection dialog box appears as a button (Filter Selection or Highlight Selection) in the bottom of the window. You can click the button to access the dialog box. If you close the dialog box, all filters and highlights clear from the report output.
In the Filter Selection dialog box, click the X adjacent to the filter or highlight you want to remove. To remove all filters or highlights, click Clear All.
Also note that if you close the Filter Selection dialog box, all filters clear from the report output.
When you select a value in the Filter Selection dialog box, a value selection dialog box displays if there are more than 20 data values. Additionally, when items are selected in the value selection dialog box, the item is highlighted and checked to indicate the selection.
Selecting multiple values is available for Equals and Not Equal conditions.
The Filter Selection dialog box opens.
Values are entered either by typing a value in a text box or selecting a value from a drop-down list.
If there are more than 20 data values for the column, a value selection dialog box opens, as shown in the image below. For more information about selecting values to be filtered, see Usage Notes for Selecting Values.
The items selected are highlighted and checked, as shown in the following image.
While the value selection dialog box appears for both alphanumeric and numeric data, indicated selections only appear for alphanumeric data.
The following apply when filtering data:
If no records are returned after applying a filter, the Status Bar states Page 1 of 1 and, for example, 0 of 10 records.
The following apply when selecting values to be filtered:
You cannot type input values in the filter field.
You may not type input values in the filter field.
When a filter is applied to a report with calculations, the report refreshes and the calculated column total shows the value for the filtered data. A calculation icon appears on the pagination bar, enabling you to toggle between calculation types for the filtered data.
The calculation icon only appears when a filter is applied to a report with calculations.
Click the calculation icon on the pagination bar to toggle between calculations for the filtered data. Note that the column total value changes accordingly, as shown in the following images.
How to: |
In addition to using column controls to filter and highlight your report, you can also filter, highlight, and comment individual rows of data in the active report output.
When a row is selected, the context menu offers options to add comments, highlight values and rows, and filter cells.
For example, the following image shows the context menu for a row in the active report output.
You can add multiple comments per row. Comments cannot be edited but they can be deleted.
The Add Comment dialog box opens.
A comment icon indicates that there is a comment in the row.
If you are using WebFOCUS theme and style files that are packaged with the product, an earlier version of the comment indicator [*] may be displayed, as shown in the following image.
The Add Comment dialog box opens displaying the comment entry and the date it was created.
The comment date and entry is shown in the output.
Comments cannot be edited.
The Add Comment dialog box opens.
The comment is removed.
To highlight a row:
Select the row of data that you want to highlight, and click and select Highlight Row from the context menu.
The row is highlighted in yellow.
You can highlight multiple rows.
To highlight a value:
Select the row of data that you want to highlight, and click and select Highlight Value from the context menu.
The row is highlighted in an aqua color.
Highlight Value is only applicable for one row. When you apply Highlight Value, any other highlighted rows are unhighlighted.
You can use the context menu to highlight other rows, unhighlight the row, or unhighlight all rows.
The filter option enables you to filter the output and only show a selected row of data.
The output refreshes and only shows the filtered row of data.
WebFOCUS |