Working with predefined data formats

When you use an information object data source to create a BIRT report, BIRT Studio translates any predefined Actuate data formats as described in the following section.

Table 2-8 shows examples of how BIRT Studio translates predefined numeric data formats.

Table 2-8

Working with predefined numeric formats

Predefined Actuate format	BIRT Studio format
General number	General Number
Currency	##,##0.00
Fixed	Fixed
Standard	Standard
Percent	0.00%
Scientific	Scientific

Table 2-9 shows examples of how predefined date-and-time formats in the English locale, are translated by BIRT Studio.

Table 2-9

Working with predefined date-and-time formats in the English locale

Predefined Actuate format	Data in original format	BIRT 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 2-10 shows examples of predefined custom format patterns and their effects on a date that is stored as 04/15/2006 in the data source.

Table 2-10

Working with predefined custom date-and-time format patterns

Predefined Actuate format	Data in original format	BIRT 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, BIRT Studio translates that format to the default format. BIRT 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.

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2