Cisco Systems OL-24201-01 manual Formatting Data Types, Data type Option Description, 13-30

Chapter 13 Managing Reports

Formatting Reports in Interactive Viewer

Formatting Data Types

In an information object, as in the relational databases on which information objects are based, all the data in a column is of the same data type, excluding the column header. The column can display numeric data, date-and-time data, or string data.

Each data type has a range of unique formats. Numeric data, for example, can appear as currency, percentages, or numbers with decimal values. Similarly, dates can be long dates, which include the full name of the month, or short dates, in which the month is represented by a number.

Table 13-6shows the data type formats you can use. Most of the examples in the table reflect the U.S. English locale. If you work in a different locale, you can use the Custom format option to format data for your locale

.

Table 13-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.

	User Guide for Cisco Secure Access Control System 5.3
13-30	OL-24201-01