You can format the threshold in the report using the Format Threshold Editor. For examples, images, and an introduction to thresholds, see the Basic Reporting Guide.
Type a name for the threshold in the Name field.
To replace the threshold values with text, an image, or a quick symbol, select the Replace Data check box and select one of the following from the drop-down list.
Replace Text: Select this option to display your own text. This replaces the values that meet your threshold condition with text. Then type the text in the empty text field. The text should be limited to 255 characters. For example, for sales opportunities that have been lost, you might display the word LOST in red. A common use of this option is to display the word EMPTY when a data value is null.
Quick Symbol: Select this option to replace the values that meet your threshold condition with a symbol. Then select a symbol from the drop-down list. For example, in a report showing the financial contribution of sales groups to overall sales, you can display a green plus + or a red minus – symbol to represent positive or negative contributions.
Image: Select this option to replace the values that meet your threshold condition with an image file. Specify the path to where the image is stored. The image should be stored in the Web Services folder.
Select one of the following tabs to access the formatting options for your report. Click the following links for details about the options in each tab:
Font: Change the font and color
of letters and numbers in the report, and change the background by applying
gradients and other effects.
To change cell background (fill) color:
If DHTML is enabled, use the Fill Color option on the Color and Lines tab.
If DHTML is disabled, use the Fill Color drop-down list on the Font tab.
Number: Specify a number format for values. For example, you can ensure that certain metric values are displayed as percentages.
Alignment: Specify how values and text are aligned within cells on the grid report.
Color and Lines: Change
the formatting of lines in your grid report, such as cell borders.
To format cell borders:
If DHTML is enabled, use the Borders options on the Color and Lines tab.
If DHTML is disabled, use the Borders tab in the Format panel.
Click Apply to apply the changes to the threshold, or click OK to apply the changes and close the editor.