Suppression Mode

The Suppression Mode application setting works with the suppression options for No Data/Missing and Zero in Oracle Smart View for Office. In the web application, your administrator can use the Suppression Mode setting to change suppression behavior.

In the Smart View Options dialog, Data Options tab, you select the No Data/Missing and Zero options for Suppress Rows, Suppress Columns, or both. The settings you make in Smart View then work with the setting in your web application.

The Suppression Mode options in the web application and their effect inSmart View are:

• Suppress Missing values only—In the web application, the administrator enables this option to suppress rows, or columns, or both that contain No Data/Missing.

  For example, in Smart View, if the No Data/Missing option for rows is selected, and a row contains only Missing data, then the row is suppressed; it is not displayed. If both the No Data/Missing and Zero suppression options are selected in Smart View for rows, and a row contains both zeroes and Missing data, then the row is displayed; it is not suppressed.

• Suppress Missing also Suppresses Zero—In the web application, the administrator enables this option to suppress rows, or columns, or both that contain all No Data/Missing or all Zeros, or a combination of both.

  In Smart View, you must enable the No Data/Missing and Zero options for Suppress Rows, Suppress Columns, or both to see the result in an ad hoc grid.

  For example, in Smart View, if both the No Data/Missing and Zero suppression options are selected for columns, and a column contains both zeroes and Missing labels, then the column is suppressed; it is not displayed. Columns that contain only zeroes, and columns that contain only Missing labels are also suppressed; they are not displayed.

See Data Options for general information on the suppression options available in Smart View.