Skip to main content

PivotGridFieldBase.EmptyValueText Property

Gets the text used for an empty field value header.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.1.Core.dll


public string EmptyValueText { get; set; }

Property Value

Type Description

A string which represents an empty field value.


The field values of column fields and row fields are listed as headers along the control’s top and left edge. If a specific field value is NULL (or DBNULL) the corresponding header displays an empty string. The EmptyValueText property allows you to specify the text which will be displayed within empty field value headers.

The filter dropdown of the field which contains NULL values has a Show Blanks check box. If it is checked the records which contain NULL values in the field will be processed by the XtraPivotGrid control. Otherwise, these records will not be processed. If the EmptyValueText property is set to a specific non-empty string, this string will be displayed instead of the Show Blanks text.

To control the display of NULL values for a specific field via code, use the PivotGridFieldFilterValues.ShowBlanks property.

See Also