DisplayEmptyRow Property

Microsoft Excel Visual Basic

Show All

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.

expression.DisplayEmptyRow

expression   Required. An expression that returns a PivotTable object.

Remarks

The PivotTable must be connected to an Online Analytical Processing (OLAP) data source to avoid a run-time error.

Example

This example determines the display settings for empty rows in a PivotTable. It assumes a PivotTable connected to an OLAP data source exists on the active worksheet.

Sub CheckSetting()

    Dim pvtTable As PivotTable

    Set pvtTable = ActiveSheet.PivotTables(1)

    ' Determine display setting for empty rows.
    If pvtTable.DisplayEmptyRow = False Then
        MsgBox "Empty rows will not be displayed."
    Else
        MsgBox "Empty rows will be displayed."
    End If

End Sub