Cisco Systems CSACS3415K9 Formatting Custom Numeric Data, Formatting String Data, Formatting Custom String Data

13-33
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Formatting Reports in Interactive Viewer
Formatting Custom Numeric Data
To define a custom format, you use special symbols to construct a format pattern. A format pattern shows
where to place currency symbols, thousands separators, decimal points or commas. Table 1 3-7 shows
examples of custom format patterns and their effects on numeric data
.
Step1 Select a numeric data column, then click Format.
The Number column format appears.
Step2 In the Format Number as field, select Custom from the drop-down list.
A second field, Format Code, appears.
Step3 In Format Code field, type a format pattern similar to those shown in Table13-7.
Step4 Click Apply.
Formatting String Data
Step1 To define the format for a column that contains string data, select the column, then click Format.
The String column format appears.
Step2 Select an option from the drop-down list. See Tabl e 13-6 for the standard string data type options.
Step3 Click Apply.
Formatting Custom String Data
You can format string data to include special formatting, such as a space or a punctuation mark at a
specific place in the string. For example, you can display telephone numb ers in one of the following
formats.
(415) 555-2121 ext. 2296
415.555.2121
Table13-7 Results of Custom Number Format Patterns
Format pattern Data in the data set Result of formatting
0000.00 12.5
124.5
1240.553
0012.50
0124.50
1240.55
#.000 100
100.25
100.2567
100.000
100.250
100.257
$#,### 2000.00
20000.00
$2,000
$20,000
ID # 15 ID 15