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.