Skip to main content

PivotGridOptionsOLAP.ShowRowsWithNoData Property

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

Namespace: DevExpress.XtraPivotGrid

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

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


public bool ShowRowsWithNoData { get; set; }

Property Value

Type Default Description
Boolean false

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

Property Paths

You can access this nested property as listed below:

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


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

See Also