PivotGridOptionsOLAP.ShowRowsWithNoData Property
In This Article
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
#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 Show |
---|---|---|
Win |
Pivot |
|
ASP. |
Pivot |
|
ASP. |
ASPx |
|
#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