SuppressMissingColumns (Property)

Applies To:

QueryOptions object

Description

Suppresses the return of data columns that contain only missing data in the CubeQuery section.

Action:

Read-write, Boolean

Example:

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

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