Skip to main content

Vertical Grid Header Filter

  • 2 minutes to read

Row headers can display filter buttons. Clicking a filter button invokes a filter dropdown, which lists unique values within a row, and enables you to apply filter criteria against this row. The buttons are hidden by default. To show filter buttons, set the ShowHeaderFilterButton property to true. You can control the filter button availability for individual rows using a row’s AllowHeaderFilter property.

Note that if a filter is applied to a row, other row header filters display unique values of the sorted records. To show the full list of values (include values of records hidden by sorting), hold down SHIFT and click a header filter button.

Header Filter Modes

Use the Mode property to specify a column’s filter mode. You can set the following filter modes for a grid data column.

List
The header filter is displayed as a regular list of filter items. Clicking an item invokes a corresponding action and automatically closes the dropdown.
CheckedList
The header filter is displayed as a checked list of filter items. In this mode, an end-user can select more than one item simultaneously. When the dropdown window is closed by clicking the OK button, the grid will display those records that contain the checked values.
DateRangeCalendar
(For date columns only). The header filter displays a calendar and a set of predefined items. Use the SettingsHeaderFilter.DateRangeCalendarSettings property to customize the calendar settings.
DateRangePicker
(For date columns only). The header filter displays a date range picker and a set of predefined items. Use the SettingsHeaderFilter.DateRangePickerSettings property to customize the editor settings.
NumericRangePicker
(For numeric columns only). The header filter displays two spin editors and a track bar. Use the SettingsHeaderFilter.NumericRangeSpinEditSettings property to customize settings of the spin editors.

Custom Header Filter Items

The ASPxVerticalGrid control allows you to create custom filter values, define their filter criteria, and display these values within a column’s drop-down filter.

You can handle the following events to customize the header filter items.

BeforeHeaderFilterFillItems
Enables you to provide custom filter items instead of default items displayed in the header filter.
HeaderFilterFillItems
Enables you to add custom filter items which filter data by the current row to ones displayed within a header filter.
See Also