13-32
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Formatting Reports in Interactive Viewer
The data type of a column is determined by the data source. Keep in mind that a text or string data type
can contain numeric digits. A telephone number, for example, is frequently string data in the data source.
The title of the formatting dialog box tells you what data type the column contains.
Step1 Select a column that contains numeric data, then select Format.
The Number column format dialog box appears.
Step2 In the Format Number as field, select General Number, Currency, Fixed, Percent, or Scientific.
The bottom section of Number column format displays fields that support that type of formatting.
Step3 In Symbol field, select a currency symbol.
Step4 In Symbol Position:
•Select Before to place the currency or percentage symbol before the number.
•Select After to place the symbol after the number.
Step5 In Decimal Places, select the number of places after the decimal marker to display
Step6 Select Use 1000s Separator if you want to use a thousands separator such as a comma (,) or a period (.).
Your locale settings determine the separator character.
Step7 In Negative Numbers, select an option for displaying negative numbers, by using either a minus sign
before the number or parentheses around the number.
Step8 Click Apply.
Formatting Fixed or Scientific Numbers or Percentages
Step1 Select a column that contains numeric data, then click Format.
The Number column dialog box appears.
Step2 In Format Number as field, select Fixed, Scientific, or Percent.
Step3 In Decimal Places field, select the number of decimal places to display.
Step4 Select Use 1000s Separator if you want to use a thousands separator such as a space, a comma (,), or a
period (.).
Step5 In Negative Numbers, select an option for displaying negative numbers: use a minu s sign before the
number, or use parentheses around the number.
Step6 Click Apply.