PivotGridOptionsOLAP.ShowColumnsWithNoData Property

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

Namespace: DevExpress.XtraPivotGrid

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

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
Reporting XRPivotGrid
.OptionsOLAP.ShowColumnsWithNoData
ASP.NET MVC Extensions MVCxPivotGrid
.OptionsOLAP.ShowColumnsWithNoData
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