Action Level Exceedance - Display Formatting

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Reports > Crosstab Reports >

Action Level Exceedance - Display Formatting

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.

 

15382-wl_demo_example
 

Add the desired action level(s) and/or warning level(s) to the Row or Column Header(s).
 

15382-add_exceedance
 

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.

 

15382-addcustomcolors

 

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.

 

15382-outputexample

 

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.