SuppressZeroRows (Property)

Applies To:

In the OLAPQuery section, applies to Database (Essbase and DB2 OLAP) specific object. In the CubeQuery section, applies to the QueryOptions object.

Description:

Enables the suppression of any zero rows where all cells are null.

Action:

Read-write, Boolean

Example 1:

This example shows how to suppress empty rows in an OLAPQuery:

ActiveDocument.Sections["OLAPQuery"].DBSpecific.SuppressZeroRows=true

Example 2:

his example shows how to enable the SuppressZeroRows (Property) when a check box is checked.

if (ActiveDocument.Sections["QueryOptions"].Shapes["CheckBox3"].Checked)
	{ ActiveDocument.Sections["Query"].QueryOptions.SuppressZeroRows = true}
else {ActiveDocument.Sections["Query"].QueryOptions.SuppressZeroRows= false}