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 7‑8 shows examples of how Report Studio translates predefined numeric data formats.
Table 7‑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 7‑9 shows examples of how predefined date‑and‑time formats in the English (United States) locale, are translated by Report Studio.
Table 7‑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 7‑10 shows examples of the effects of predefined custom format patterns on a date stored as 04/15/2006 in the data source.
Table 7‑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.