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

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

#Declaration

[DefaultValue(false)]
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
ASP.NET MVC Extensions PivotGridSettings
.OptionsOLAP .ShowRowsWithNoData
ASP.NET Web Forms Controls ASPxPivotGrid
.OptionsOLAP .ShowRowsWithNoData

#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