PivotGridOptionsOLAP.ShowColumnsWithNoData Property

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v23.1.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Dashboard.Design

Declaration

C#

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

VB.NET

<DefaultValue(False)>
Public Property ShowColumnsWithNoData As Boolean

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 Web Forms Controls	ASPxPivotGrid	.OptionsOLAP .ShowColumnsWithNoData
ASP.NET MVC Extensions	PivotGridSettings	.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.