Use that button to display the available formats depending on the field type.Format Properties
That property allows specifying the format to be used to display the data field content when editing or printing the report or the data grid.
Note: ClicknDECiDE Builder proposes automatically several default formats depending on the field type (text, numeric, date, time or timestamp). You can modify them.
You can use the Format Tab in the Properties Dialog Box to see or modify it.
Use that button to display the available formats depending on the field type.
The Format property uses the following parameters:
Warning: it is recommended to use the same thousand and decimal separator as the one used by Windows in order to be automatically updated if you change later the regional settings.
|
Parameter |
Description |
|
_________________________ |
_____________________________________________ |
|
0 |
Enter a Zero to get an entire value without decimals (enter a # in order to do not display the value zero) |
|
0,00 |
Example for numeric value without thousand separator and semicolon as decimal separator |
|
#.### |
Example to get numeric values with a dot as thousand separator, without decimals and do not display nothing if the value is zero |
|
#.##0 |
Example to get numeric values with a dot as thousand separator, without decimals and display the zero if the value is zero |
|
#.##0,00 |
Example for numeric value with a dot as thousand separator and semicolon as decimal separator and display 0,00 if the value is zero. |
|
#.### £ |
Currency with the English pound without decimals |
|
#.##0,00;-#.##0,00;<Null> |
Example for numeric value with a dot as thousand separator, a semicolon as decimal separator, a minus sign for negative values and a Null information for null content. |
|
# ##0,00 ;-# ##0,00 ;<Null> |
Example for numeric value with a space as thousand separator , a semicolon as decimal separator, a for Euro money, a minus sign for negative values and a Null information for null content. |
|
0% |
Example for numeric value with a percentage presentation, without decimal |
|
dd/mm/yyyy |
Example for a date value, with 2 numbers for the day, 2 numbers for the month and 4 numbers for the year. |
|
dd/mmm/yyyy |
Example for a date value, with 2 numbers for the day, 3 first characters for the month and 4 numbers for the year. |
|
dddd d mmmm yyyy |
Display a date value with the full day name, then the day number with 1 or 2 digits, the full month name and the year with 4 digits. |
|
hh:mm:ss |
Example for a time value, with 2 numbers for the hour, 2 numbers for the minutes and 2 numbers for the seconds. |
|
dd/mm/yy hh:mm |
Example for a timestamp value, with 2 numbers for the day, 2 numbers for the month, 2 numbers for the year, 2 numbers for the hour, 2 numbers for the minutes and no seconds. |