PivotGridFieldBase.EmptyValueText Property
Gets the text used for an empty field value header.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v24.1.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
[XtraSerializableProperty]
[XtraSerializablePropertyId(1)]
public string EmptyValueText { get; set; }Property Value
| Type | Description |
|---|---|
| String | 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.