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

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.
  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
    Use the Manage subscribers list to add the names of users that you want notified when the alert condition is met.
  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
  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 table using color-mapped values:
  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 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.
  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.
Copyright © SAS Institute Inc. All rights reserved.