PivotTable.DisplayEmptyRow Property
Returns True when the non-empty MDX keyword is included in the query to the OLAP provider for the category axis. The OLAP provider will not return empty rows in the result set. Returns False when the non-empty keyword is omitted. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property DisplayEmptyRow As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.DisplayEmptyRow
instance.DisplayEmptyRow = value
bool DisplayEmptyRow { get; set; }
Property Value
Type: System.Boolean
Remarks
The PivotTable must be connected to an Online Analytical Processing (OLAP) data source to avoid a run-time error.