PromptForZeroSuppression Property

Sets or returns whether the report consumer can apply or turn off zero suppression in a report published to the IBM® Cognos® portal.

Syntax

DeploymentOptions.PromptForZeroSuppression

Discussion

Use this property when a row or column in a report contains all zeros, or all zeros and a rank category, and this information is not necessary. This reduces the size and improves the readability of the report. The report consumer can customize the report in the IBM Cognos portal by selecting whether to suppress zeros on rows, columns, or on both rows and columns.

By default, the report uses the suppression mode specified by the report author when it was created.

Default: False

Type

Boolean

Access

Read/Write

Example

This example specifies the prompts that the report consumer sees when the report is opened in the IBM Cognos portal.

Sub Main()

   Dim objPPRep as Object

   Dim objDeploymentOptions as Object

   Set objPPRep = GetObject(,"CognosPowerPlay.Report")

   Set objDeploymentOptions = objPPRep.DeploymentOptions

   objDeploymentOptions.PromptForCurrency = True

   objDeploymentOptions.PromptForLongShortNames = True

   objDeploymentOptions.PromptForZeroSuppression = True

   objDeploymentOptions.PromptForSwapRowsAndColumns =
True

   objPPRep.Save

   Set objDeploymentOptions = Nothing

   Set objPPRep = Nothing

End Sub