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.v23.2.Core.dll
NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
Declaration
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.