[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Collapse]Vertical Grid
   [Expand]Binding to Data
   [Expand]Data Layout: Records, Rows and Cells
   [Expand]Data Editing and Validation
    Formatting Values
   [Expand]Drag and Drop
   [Expand]Appearance and Custom Painting
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]End-User Capabilities
    Hit Information
    Batch Modifications
   [Expand]Member Tables
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation


The Vertical Grid control supports filtering that allows it to only display a part of data that meet particular criteria. Data can be filtered against single or multiple grid rows (fields in the data source), using a simple or complex criterion for each filtered row. End-users can apply filtering using Filter Dropdowns in row headers, or build a filter in the Filter Editor.

Expanded Filter Dropdowns

An end-user can invoke the Filter Dropdown by clicking the Filter Buttons in the row header. The Filter Dropdown contains a list of available data values for the current row and provides predefined filters based on the row's data type.

Filtering is enabled in the Vertical Grid control by default. You can disable filtering for the whole control or a particular row using the VGridOptionsFilter.AllowFilter and VGridOptionsRowFilter.AllowFilter properties, respectively. If filtering is disabled, the filter buttons are hidden, and data cannot be filtered.

A row's Filter Dropdown only contains data values that meet filter criteria already applied to other rows, by default. Pressing SHIFT while clicking the filter button in the row header shows all the available data values. However, you can specify that the control always displays all the available data values by enabling the VGridOptionsFilter.ShowAllValuesInFilterPopup option.

Expanded Filter Panel

Once a filter is applied to data, the Filter Panel is displayed.

The Filter Panel is only displayed when a filter is applied, and automatically hides otherwise (by default). You can specify that the Panel is always or never visible using the VGridOptionsView.ShowFilterPanelMode property.

The main purpose of the Filter Panel is to indicate which filter is currently applied. You can customize the filter's textual representation by handling the VGridControl.CustomFilterDisplayText event.

The drop-down button in the Filter Panel invokes a list of recently applied filters. You can disable this functionality or limit the number of items in the list (the default is 7) using the VGridOptionsFilter.AllowMRUFilterList and VGridOptionsFilter.MRUFilterListPopupCount options.

Clicking on the "Edit Filter" button invokes the Filter Editor which allows an end-user to create a filter. The Editor provides the visual (the default) and text views. The VGridOptionsFilter.DefaultFilterEditorView option allows you to override the default view.

The result is shown below.

Starting with version 18.1, this legacy Filter Editor is replaced with its updated version that features the advanced "Text" tab, where you can type filter expressions manually. This tab now supports syntax highlighting and auto-complete to facilitate the input. To revert data-aware controls back to the legacy Filter Editor version, disable the static WindowsFormsSettings.UseAdvancedFilterEditorControl property.

Expanded See Also

Is this topic helpful?​​​​​​​