PivotGridFieldOptions.HideEmptyVariationItems Property

Gets or sets whether the first (empty) column/row that displays variation data for the current data field must be hidden.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

C#

[DefaultValue(false)]
[XtraSerializableProperty]
[TypeConverter(typeof(BooleanTypeConverter))]
public bool HideEmptyVariationItems { get; set; }

VB.NET

<DefaultValue(False)>
<XtraSerializableProperty>
<TypeConverter(GetType(BooleanTypeConverter))>
Public Property HideEmptyVariationItems As Boolean

Property Value

Type	Default	Description
Boolean	**false**	true if the first (empty) column/row that displays variation data for the current data field must be hidden; otherwise, false.

Property Paths

You can access this nested property as listed below:

Library	Object Type	Path to HideEmptyVariationItems
Cross-Platform Class Library	PivotGridFieldBase	.Options.HideEmptyVariationItems
WinForms Controls	PivotGridField	.Options.HideEmptyVariationItems
ASP.NET Controls and MVC Extensions	PivotGridField	.Options.HideEmptyVariationItems
	MVCxPivotGridField	.Options.HideEmptyVariationItems
Reporting	XRPivotGridField	.Options.HideEmptyVariationItems

Remarks

If the current field is a data field and the PivotGridFieldBase.SummaryDisplayType property is set to PivotSummaryDisplayType.AbsoluteVariation or PivotSummaryDisplayType.PercentVariation, the corresponding columns/rows display variation data. In this case, the first column/row is always empty. You can hide it via the HideEmptyVariationItems property.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the HideEmptyVariationItems property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

aspxpivotgrid-how-to-change-the-summary-display-mode-t590012/CS/SummaryDisplayMode/Default.aspx.cs#L160

    if(SummaryDisplayTypeDataField != null)
        SummaryDisplayTypeDataField.Options.HideEmptyVariationItems = cbHideEmptyVariationItems.Checked;
}

VB.NET

aspxpivotgrid-how-to-change-the-summary-display-mode-t590012/VB/SummaryDisplayMode/Default.aspx.vb#L177

If SummaryDisplayTypeDataField IsNot Nothing Then
    SummaryDisplayTypeDataField.Options.HideEmptyVariationItems = cbHideEmptyVariationItems.Checked
End If