PivotGridFieldBase.EmptyValueText Property

Gets the text used for an empty field value header.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue("")]
public string EmptyValueText { get; set; }

VB.NET

<DefaultValue("")>
Public Property EmptyValueText As String

Property Value

Type	Default	Description
String	String.Empty	A string which represents an empty field value.

Remarks

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.