13-31
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Formatting Reports in Interactive Viewer
.
Formatting Numeric Data
Numeric data can take several forms. A column of postal codes re quires different formatting from a
column of sales figures. Figure 13-16 shows the numeric formats you can use.
Figure 13-16 Formats for Numeric Data
Table13-6 Data Types and Formats
Data type Option Description
Date and Time Unformatted Data retains the default format set by the template or theme.
General Date June 5, 2006 12:00:00 AM GMT +00:00
Long Date June 5, 2006
Medium Date Jun 5, 2006
Short Date 6/5/06
Long Time 12:00:00 AM GMT +00:00
Medium Time 12:00: 00 AM
Short Time 12:00
Custom Format depends on a format code you type. For example, typing
yyyy/mm results in 2006/10. You learn more about custom
formatting later in this chapter.
Number Unformatted Number retains the default format set by the template or theme.
General Number 6066.88 or 6067, depending on the decimal and thousands
separator settings
Currency $6,067.45 or ¥6067, depending on the locale and optional
settings
Fixed 6067 or 6,067 or 6067.45, depending on optional settings
Percent 45% or 45.8%, depending on optional settings
Scientific 2E04 or 2.67E04, where the number after the E represents the
exponent of 10, depending on optional settings. For example,
2.67E04 means 2.67 multiplied by 10 raised to the fourth power.
Custom Format depends on a format code you type. For example, typing
#,### results in a format with a comma as a thousands separator
and no decimal points. You learn more about custom formats
later in this chapter.
String Unformatted String retains the default format set by the template or theme.
Uppercase String displays in all uppercase, for example GREAT NEWS.
Lowercase String displays in all lowercase, for example great news.
Custom Forma t depends on the format code you type. Use custom
formatting for postal codes, telephone numbers, and other data
that does not match standard formats.