Using Actuate BIRT Viewers : Editing and formatting a report : Formatting data strings : Applying a number format : Defining a custom number format
 
Defining a custom number format
You can define a custom number format using special symbols to construct a format pattern. A format pattern shows where to place currency symbols, thousands separators, decimal points, or commas. Table 3‑2 shows examples of custom format patterns and their effects on numeric data.
Table 3‑2 Results of custom number formats
Format pattern
Data in the database
Result of formatting
0000.00
12.5
124.5
1240.553
0012.50
0124.50
1240.55
#.000
100
100.25
100.2567
100.000
100.250
100.257
$#,###
2000.00
20000.00
$2,000
$20,000
ID #
15
ID 15