Adding Table-Level Display Rules

You can add three different types of display rules to tables. You cannot create a display rule to highlight dates in a table.
Add Display Rules to a List Table Using an Expression
Add Display Rules to a List Table Using a Gauge
Add Display Rules to a List Table Using Color-Mapped Values
Add Display Rules to a Crosstab

Add Display Rules to a List Table Using an Expression

To specify a new display rule for a table using an expression:
  1. If it is not already selected, select the table in the canvas that you want to update.
  2. In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
  3. Click Expression. The Add New Display Rule window expands to show the details for the expression.
    Add New Display Rule Window for an Expression
  4. On the Expression Details tab, select the Column or any measure value.
  5. Select the Operator. You can select =, < >, BetweenInclusive, <, <=, >, >=, Missing, or NotMissing. The default is >.
  6. Enter or select a Value.
  7. Modify the style, size, and color of the font. There is no default style for list table display rules. You must specify a style to enable the OK button in the Add New Display Rule window.
  8. Select the row or column in the Applies to drop-down list.
  9. (Optional) On the Alert Options tab, select the Create an alert based on this rule check box. For more information about alerts, see Working with Alerts for Report Objects.
    Add New Display Rule Window for an Expression Showing an Alert
    1. Click the Add button beside the Manage subscribers list to add users who you want notified when the alert condition is met. The Add Recipients window is displayed.
    2. Select one or more users. Click OK to return to the Add New Display Rule window.
      Note: A user’s e-mail address must be stored in metadata to be displayed on the View All tab in the Add Recipients window.
  10. Click OK. The table updates with the new display rule. The display rule appears on the Display Rules tab in the right pane.
    Here is an example of a display rule that uses an expression:
    Display Rules Tab with the Display Rules for an Expression in a List Table
  11. (Optional) Click edit icon on the Display Rules tab to edit the new display rule.

Add Display Rules to a List Table Using a Gauge

To specify a new display rule for a table using a gauge:
  1. If it is not already selected, select the table in the canvas that you want to update.
  2. In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
  3. Click Gauge. The Add New Display Rule window expands to show the details for the gauge.
    Add New Display Rule Window for a Gauge
  4. Select a Gauge type from the drop-down list. Your choices are a bullet, an icon, a slider, or a thermometer. Icon is the default.
  5. Using the Based on column drop-down list, specify which column the rule should be based on in the report.
  6. Specify where the gauge should appear in the column for the Cell placement. Your choices are Left of text, Right of text, or Replace text.
  7. Define the intervals and colors for the rule:
    • Enter the individual values for the intervals and then select a color. You can click the operator between the intervals to change it.
    • Click populate interval icon to automatically populate the intervals. The Populate Intervals window is displayed.
      You can specify Number of intervals, Lower bounds, and Upper bounds. Click OK.
  8. Specify the Column in which you want the gauge to be displayed
  9. Click OK. The table updates with the new display rule. The display rule appears on the Display Rules tab in the right pane.
    Here is an example of an automatically populated display rule that uses an icon:
    Display Rules Tab with the Display Rules for an Icon
    Here is a list table with the display rules applied:
    A List Table with Icons for the Display Rules
    Note: If a value falls outside the bounds of the display rule intervals, no icon is displayed in the list table
  10. (Optional) Click edit icon on the Display Rules tab to edit the new display rule.

Add Display Rules to a List Table Using Color-Mapped Values

To specify a new display rule for a list table using color-mapped values:
  1. If it is not already selected, select the list table in the canvas that you want to update.
  2. In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
  3. Click Color-mapped Values. The Add New Display Rule window expands to show the details for the color-mapped values.
    Add New Display Rule Window for Color-Mapped Values
  4. Select the Column or value to which you want to apply the display rule.
    Note: Color-mapped values for a report object can be applied only to category data items.
    Note: Color-mapped values cannot be applied to date or datetime data items.
  5. Click in the box to enter a value for the display rule.
  6. Select a color for the display rule.
  7. (Optional) Repeat the steps for entering a value and selecting a color.
  8. (Optional) Select the Other check box. Then, select a color.
  9. Using the list, specify where you want to apply the colors.
    In the following example, values and colors have been specified for products in a list table.
    Add New Display Rule Window for Color-Mapped Values
  10. Click OK. The table updates with the display rules.
    The display rule appears on the Display Rules tab in the right pane.
    Display Rule for Color-Mapped Values
  11. (Optional) Click move icon on the Display Rules tab to change the table-level display rule to a report-level display rule.

Add Display Rules to a Crosstab

To specify a new display rule for a crosstab using an expression:
  1. If it is not already selected, select the crosstab in the canvas that you want to update.
  2. In the right pane, click the Display Rules tab. Click New. The Add New Display Rule window is displayed.
    Add New Display Rule Window for an Expression
  3. On the Expression Details tab, select the Column or any measure value.
  4. Select the Operator. You can select =, < >, BetweenInclusive, <, <=, >, >=, Missing, or NotMissing. The default is >.
  5. Enter or select a Value.
  6. If your crosstab contains a hierarchy, then you can specify the hierarchy levels in which the display rule is applied.
    1. Click Specify Intersections. The Specify Intersections window is displayed.
      Specify Intersections Window
    2. Select one or more hierarchy levels, the grand total, or all of the levels. Click OK to return to the Add New Display Rule window. The intersections that you selected are displayed above the Edit Intersections button.
  7. Modify the style, size, and color of the font.
  8. Select the row or column in the Applies to drop-down list. For crosstabs, the Applies to drop-down list displays only the measures that have been added to the crosstab. There are no row or column options.
  9. (Optional) On the Alert Options tab, select the Create an alert based on this rule check box. For more information about alerts, see Working with Alerts for Report Objects.
    1. Click the Add button beside the Manage subscribers list to add users who you want notified when the alert condition is met. The Add Recipients window is displayed.
    2. Select one or more users. Click OK to return to the Add New Display Rule window.
      Note: A user’s e-mail address must be stored in metadata to be displayed on the View All tab in the Add Recipients window.
  10. Click OK. The crosstab updates with the new display rule. The display rule appears on the Display Rules tab in the right pane.
  11. (Optional) Click edit icon on the Display Rules tab to edit the new display rule.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019