PivotGridOptionsOLAP.ShowRowsWithNoData Property

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

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

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

VB.NET

<DefaultValue(False)>
Public Property ShowRowsWithNoData As Boolean

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 MVC Extensions	MVCxPivotGrid	.OptionsOLAP .ShowRowsWithNoData
	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.