Adding report exceptions

To add a report exception:

  1. Highlight the data you want to color code. You can select a cell, range of cells, or an entire row or column.
  2. Right-click and select Exceptions > Report > Add.
  3. Specify a name for the exception.
  4. Click Add to add a data range.
  5. Select the Enforce Consecutive Ranges check box if you want the ranges to be consecutive. If the Enforce Consecutive Ranges check box is not selected, the additional ranges do not need to be consecutive. For example, the minimum (bottom) amount for the second range does not need be the maximum (top) amount from the first range.
  6. For consecutive ranges, start with the top value in the range. The first value is automatically determined. For non-consecutive ranges, specify the bottom and top values. If you have non-consecutive ranges, select the Includes Bottom and Includes Top check boxes to include the specified value in the report exception.
    If you define two or more ranges, an exception displays if a value falls within any of the ranges. The range applies to actual database values (not rounded values displayed on a view). For example, if a range is defined as 1-100 (values greater than 1 and less than or equal to 100), a .96 database value that is rounded to 1 on a view will not show up on the alert (.96 is less than 1 and therefore outside the range). But a 1.03 database value will show up on the alert, even though it also displays as1 on the same view.
  7. Select the Back Color. This color is used as the background color for the cell.
  8. Select the Font Color. This color is used for the text.
  9. Select the Display as Exception Micro Bar check box to color code the cell in proportion to all corresponding cells in the row or column. To ensure visibility of the color coding, the first 20% of the cell is always colored and the proportional representation starts from that point. If you selected a single cell, the proportion calculation is based on the cell value.
  10. Optionally, select the Gradient Colors check box to fade the color from one end of a data point to the other.
  11. Continue through the remaining ranges.
  12. Click OK.
  13. To retain the report exception color coding, save the view as a private view.