Using the Advanced Option in Conditional Suppression

The Advanced Option is used to suppress rows or columns in a grid based on specified attributes or values. Conditional suppression can be simple or complex, and can contain a maximum of seven conditions. Advanced conditional suppression can be combined with basic suppression options. See Using the Basic Option in Conditional Suppression.

When you define conditions, you can include the Not operator to suppress rows or columns that do not meet the condition (that result in false), and parenthesis to enclose and separate conditions from other conditions. Conditional suppression may be based on data or formula values.

  To apply conditional suppression:

  1. Create a report, or open an existing report containing a grid.

  2. Select the rows, columns, or grid to which you want to apply suppression.

  3. In the property sheet, click Advanced Options, then click the Setup button to display the Conditional Suppression dialog box.

    Note:

    If you selected a grid, first select the Suppression category in the Grid Properties property sheet.

    Conditional Suppression displays a Basic Options label above the suppression options. Basic options use OR operators:

    • Basic Options:None—Basic options not selected with Advanced options.

    • If Zero, Suppress OR—If Zero selected with Advanced options.

    • If Zero OR Missing, Suppress OR—IfZero and If Missing selected with Advanced options.

    • If Zero OR Error, Suppress OR—If Zero and If Error selected with Advanced options.

    • If Zero OR Missing OR Error, Suppress OR—If Zero, If Missing and If Error selected with Advanced options.

    • If Missing, Suppress OR—If Missing selected with Advanced options.

    • If Missing OR Error, Suppress OR—If Missing and If Error selected with Advanced options.

    • If Error, Suppress OR—If Error selected with Advanced options.

  4. From Suppress Row or Column If, select a property.

  5. From the Reference Value drop-down list box, select a value corresponding to the property value you selected from the Suppress Row or Column If drop-down list box.

  6. Select one of the following operators, if applicable:

    Note:

    The available operators depend on your property selection.

    • < > (less than or greater than)

    • > (greater than)

    • > = (greater than or equal to)

    • < (less than)

    • < = (less than or equal to)

    • not equals (is not equal to)

    • starts with

    • ends with

    • contains

    • Is

  7. Select one of the following comparison options, if applicable:

    Note:

    The available comparison options depend on your property selection.

    • Number—Enables the assignment of a certain value to a cell.

    • Cell Value—Returns the cell location; for example: A, 3.

    • Row Value—Returns the number of the row.

    • Column Value—Returns the letter of the column.

    • Zero—Assigns zero value for condition.

    • No Data—Indicates no data value for selection.

    • Error—Assigns the condition as an error.

    • string—Enables the definition of a string for the condition.

    • 1, 2, 3,...—Indicates the number of levels or generations in the selected dimension.

    • Non Expense—Assigns the condition as a non-expense.

    • Expense—Assigns the condition as an expense.

    • True—Assigns a True value to the condition.

  8. To add another condition, click the Add Condition 2 button.

    Note:

    The number on this button is increased to as many as 7 as you add conditions.

  9. To combine the current condition with the following condition, select one of the following operators:

    • Select And if both combined conditions must be met.

    • Select Or if only one of the combined conditions must be met.

  10. Optional: In the Options area, add one of the following logic options to your condition:

    • Select Allow Not to allow suppression only if the condition is not met.

    • Select Allow Parentheses to define precedence, or order of consideration for the conditions, then specify the set of conditions as intended.

  11. To add another condition, click the Add Condition 3 button.

  12. Click OK to return to the grid in your report.