Skip to main content

PivotGridOptionsOLAP.ShowColumnsWithNoData Property

Gets or sets whether to show items with no data on columns.

Namespace: DevExpress.XtraPivotGrid

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

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

#Declaration

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

#Property Value

Type Default Description
Boolean false

true, to display empty columns in OLAP query results; otherwise, false.

#Property Paths

You can access this nested property as listed below:

Library Object Type Path to ShowColumnsWithNoData
WinForms Controls PivotGridControl
.OptionsOLAP .ShowColumnsWithNoData
ASP.NET MVC Extensions PivotGridSettings
.OptionsOLAP .ShowColumnsWithNoData
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsOLAP .ShowColumnsWithNoData

#Remarks

The OLAPUseNonEmpty, ShowRowsWithNoData and ShowColumnsWithNoData options allow you to filter out empty values in MDX queries when you use the NonEmpty function.

See Also