Working with predefined data formats

When you use an information object data source to create a BIRT report, Report Studio translates any predefined Actuate data formats to BIRT formats as described in the following section. Translation of data formats does not occur when you use a BIRT data object data source because data objects use BIRT data formats, which are compatible with Report Studio.

Working with a predefined number format

Table 6‑8 shows examples of how Report Studio translates predefined numeric data formats.

Table 6‑8 Working with predefined numeric formats
Predefined Actuate format	Report Studio format
General number	General Number
Currency	##,##0.00
Fixed	Fixed
Standard	Standard
Percent	0.00%
Scientific	Scientific

Working with a predefined data‑and‑time format

Table 6‑9 shows examples of how predefined date‑and‑time formats in the English (United States) locale, are translated by Report Studio.

Table 6‑9 Working with predefined date‑and‑time formats in the English (United States) locale
Predefined Actuate format	Data in original format	Report Studio format
General date	04/15/2006	General date
Long date	Thursday, April 15, 2006	Long time
Medium date	15-Apr-06	Medium date
Short date	04/15/06	Short date
Long time	12:00:00 AM	Long time
Medium time	12:00 AM	Medium time
Short time	00:00	Short time
Short week	W16 2006	''W''w yyyy
Short month	4/2006	M/yyyy
Long year	2006	yyyy

Table 6‑10 shows examples of the effects of predefined custom format patterns on a date stored as 04/15/2006 in the data source.

Table 6‑10 Working with predefined custom date‑and‑time format patterns
Predefined Actuate format	Data in original format	Report Studio format
mm‑dd‑yy	04‑15‑06	MM‑dd‑yy
ddd, m/d	Thu, 4/15	E, M/d
dddd, m/dd/yy	Thursday, 4/15/06	EEEE, M/dd/yy
mmm d	Apr 15	MMM d
mmmm	April	MMMM
''Quarter'' Q	Quarter 2	'Quarter' q
''Day'' y	Day 106	'Day' D

If an entry is not described, Report Studio translates that format to the default format. Report Studio does not convert predefined formats for other types of data, such as string data and Boolean data, and the resulting data is displayed in the default format.