Filters provide the ability to return a subset of data in the model by a field or combination of fields from the data model. Interactive Reporting provides a very robust filtering capability, where complex filters can be added to queries through an easy-to-use interface.
A filter is easily added to the query by adding the item to the Filter line. Items are added to the filter line by using one of the following two methods:
Right-click method |
Drag-and-drop method |
---|---|
Highlight the column in the table of interest. |
Highlight the column in the table of interest. |
Right-click and select Filter. |
Drag-and-drop the column into the Filter line. |
Since the filter must be configured after it is added, only one column can be added to the Filter line at a time. Once the column has been added to the Filter line, the Filter interface appears to configure the filter values for the column.