Filtering Data

Filter Dropdown List


Hover over the column header and click the filter button within the column header that appears.

Creating a Simple Filter


Invoke the filter dropdown list containing available filter values.

Select the required filter value in the filter dropdown list.


For date-time columns, the filter dropdown list is displayed as a calendar.

To apply the filter, select the desired date.

The control will immediately display records which contain the selected date in the appropriate column.

To hide the filter dropdown list, click the close button .

Advanced Filter Dialog


Right-click any column’s header and select Filter Editor.


If the filter panel at the bottom is visible, click the Edit Filter button

Clearing the Filter


To clear the filter applied to a specific column, do one of the following:

  1. Invoke the filter dropdown list (see above), and then choose between clicking (All) or selecting (Select All) or choosing (Show All,) depending on the dropdown list type.
  2. Right-click the column header and select the Clear Filter menu item.



To clear all filter criteria, click the Close Filter button within the Filter Panel.

Disable/Enable the Filter


Click the Enable Filter button within the Filter Panel.