SuppressMissingRows (Property)

Applies To:

Database (Essbase and DB2 OLAP) — specific object, QueryOptions object.

Description:

In the OLAPQuery section, this property suppresses missing rows in which all cells are null.

In the CubeQuery section, this property suppresses the return of data rows that contain only missing values. If one value is in the row, the row is not suppressed.

Action:

Read-write, Boolean

Example 1:

This example shows how to suppress empty rows in an OLAP query:

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

Example 2:

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

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