PivotGridFieldOptionsEx.FieldFilterPopupMode Property

Gets or sets the field’s pop-up filter mode.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v23.2.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

[DefaultValue(FieldFilterPopupMode.Default)]
[XtraSerializableProperty]
public virtual FieldFilterPopupMode FieldFilterPopupMode { get; set; }

VB.NET

<XtraSerializableProperty>
<DefaultValue(FieldFilterPopupMode.Default)>
Public Overridable Property FieldFilterPopupMode As FieldFilterPopupMode

Property Value

Type	Default	Description
FieldFilterPopupMode	Default	A FieldFilterPopupMode value that specifies the field’s pop-up filter mode. Default value is interpreted as FieldFilterPopupMode.Excel.

Available values:

Name	Description
Default	A default filter popup type.
Excel	An Excel-style filter popup.
Classic	A Classic filter popup.

Property Paths

You can access this nested property as listed below:

Object Type	Path to FieldFilterPopupMode
PivotGridField	.Options .FieldFilterPopupMode

Remarks

The Pivot Grid supports Excel-style and Classic pop-up filters. For more information, see Pop-up Filter.

You can specify the pop-up filter style at three levels:

1. Application level

   Use the WindowsFormsSettings.ColumnFilterPopupMode static option for all controls in your application.

2. Control level

   Use the PivotGridOptionsFilterPopup.FieldFilterPopupMode property to specify a pop-up filter’s type for the entire PivotGridControl.

C#

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

VB.NET

pivotGridControl.OptionsFilterPopup.FieldFilterPopupMode = FieldFilterPopupMode.Excel

This control level setting overrides the WindowsFormsSettings.ColumnFilterPopupMode global setting.

3. Field level

   Use the PivotGridFieldOptionsEx.FieldFilterPopupMode property to define a pop-up filter for a specific field.

C#

fieldTrademark.Options.FieldFilterPopupMode = FieldFilterPopupMode.Excel;

VB.NET

fieldTrademark.Options.FieldFilterPopupMode = FieldFilterPopupMode.Excel

The field level setting overrides the control level settings.

You cannot use the Excel-style filter in the following cases:

• the datasource type is OLAP;
• the PivotGridControl.CustomFilterPopupItems event is handled.