Filtering in the Results and Table section provides the user with significant flexibility to add, modify, and remove custom filters without the need to reprocess the query. Since the query does not need to be rerun, filtering is quick and easy in the section. In addition, Interactive Reporting documents can be saved to the local workstation populated with data allowing the document to be taken offline where the user can continue to perform filtering and analysis on the data stored in the document without needing to connect back to the database.
Filters can be created in a Results and Table section through the different options shown in the following table:
Double-click method |
Drag-and-drop method |
Right-click method |
---|---|---|
Double-click the column of data in the Results section. |
Highlight the column of data in the Results or Table section. |
Highlight the column of data in the Results or Table section. |
Drag-and-drop the column of data into the Filter line. |
Right-click... |