Skip to main content

PivotGridFieldFilterValues.ShowBlanks Property

Gets or sets whether records that contain NULL values in the current field should be processed by the control.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v22.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design


public bool ShowBlanks { get; set; }

Property Value

Type Default Description
Boolean true

true if records that contain NULL values in the current field are processed by the control; false if these records are ignored.


If a specific field contains NULL values, a “Show Blanks” check box is displayed in its filter drop-down. An end-user can toggle this check box to display or hide records that contain NULL in the current field. Checking/unchecking this check box automatically modifies the value of the ShowBlanks property.

When a field that contains NULL values is positioned within the column header area or row header area, the NULL values are represented as empty field value headers. You can use the PivotGridFieldBase.EmptyValueText property to provide custom display text to be displayed within empty field value headers. The same text will be displayed instead of the “Show Blanks” string in the field’s filter drop-down.

See Also