Action Level Exceedance - Display Formatting
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
When an Action Level Exceedance (ALE) Report is sent to the Crosstab Report Builder, the Available Columns list includes the action/warning level columns. The list below shows the WL DEMO action level as an example.
Add the desired action level(s) and/or warning level(s) to the Row or Column Header(s).
To apply variable highlighting of exceedances, click on the Display drop-down for the target action/warning level(s), and choose from the standard options for Exceedance: bold, italic or underline or select Exceedance (custom). Note that the standard options avoid potential issues with overlaying multiple formats of font and/or BackColor shading.
For custom settings, the Set Custom Exceedance Appearance dialog will appear. Expand the Font list to see the Bold, Underline, Italic, and other options. Choose True to set a desired option. Click the drop-down arrow to the right of BackgroundColor or ForegroundColor to select a custom color.
In this example, the warning level is less than the action level, so exceedance results will be highlighted in the warning level format when only the warning level is exceeded, and in the action level format if both levels are exceeded.
For the shading to work properly in the example above, the warning level must be listed first in the Row Header(s). This is not necessary when selecting the standard format options that can be combined in a single-cell display (bold, italic, underline). Read more about the column header custom coloring feature.