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.v24.2.Core.dll

Declaration

C#

[DefaultValue(true)]
public bool ShowBlanks { get; set; }

VB.NET

<DefaultValue(True)>
Public Property ShowBlanks As Boolean

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.

Remarks

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.