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.v23.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[DefaultValue(false)]
public bool HideEmptyVariationItems { get; set; }

VB.NET

<DefaultValue(False)>
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:

Object Type	Path to HideEmptyVariationItems
PivotGridFieldBase	.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 snippets (auto-collected from DevExpress Examples) contain references 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#

web-forms-pivot-grid-change-summary-display-mode/CS/SummaryDisplayMode/Default.aspx.cs#L160

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

winforms-pivot-grid-walkthrough-tutorial/CS/WinPivot_GettingStarted/Form1.cs#L21

sqlDataSource1.Fill();
pivotGridField5.Options.HideEmptyVariationItems = true;
pivotGridControl1.BestFit();

VB.NET

web-forms-pivot-grid-change-summary-display-mode/VB/SummaryDisplayMode/Default.aspx.vb#L177

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

winforms-pivot-grid-walkthrough-tutorial/VB/WinPivot_GettingStarted/Form1.vb#L15

sqlDataSource1.Fill()
pivotGridField5.Options.HideEmptyVariationItems = True
pivotGridControl1.BestFit()