•Show/Hide Filtered Rows vs Highlight Filtered Rows
The EQuIS Professional data grid offers several options for displaying filter results. The default display option uses a filter row for text input below the column header in each row, and hides rows that do not meet the filter criteria.
To access the Filter Options menu, select the dropdown arrow for the Filter 
icon on the grid toolbar, then select Options 
.
The Filter Options menu that appears has several settings:
•Show/Hide Filtered Rows or Highlight Filtered Rows radio buttons
ofor Highlight Filtered Rows, appearance settings for Included Values and Excluded Values
•Use Filter Row check box
Filter Options Preference Menu with BackColor Palette Displayed
Show/Hide Filtered Rows vs Highlight Filtered Rows
The Show/hide filtered rows option will hide all rows that do not meet the criteria set within the filter row or a custom filter. This is the default selection for filtering rows.
The Highlight filtered rows option allows the user to display values included and returned by the filter criteria as well as a separate display option for the excluded values that do not meet the filter criteria. The Included Values and Excluded Values options will be displayed if the Highlight filtered rows radio button is selected. Highlighting one value in the list will update the right pane of display options for that particular included or excluded value. These display options are similar to standard grid display options.
Use Filter Row
The Use Filter Row check box (checked by default) will add a filter row below the column header for each table or report opened in EQuIS Professional. If the Use Filter Row box is checked upon selecting the Filter icon, the filter row will display as follows.
Using a filter with Use Filter Row unselected displays a filter button next to the field name, as shown in the following image.
Any date field (the name of which will end in _date) will open a calendar when using the filter row dropdown.
