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 cross table.
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 box in the General Tab from 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:
|
Parameter |
Description |
|
_____________________ |
________________________________________________________ |
|
0,00 |
Example for numeric value without thousand separator and semicolon as decimal separator |
|
#.##0,00 |
Example for numeric value with a dot as thousand separator and semicolon as decimal separator |
|
#.##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 F;-# ##0,00 F;<Null> |
Example for numeric value with a space as thousand separator , a semicolon as decimal separator, a F for French Francs 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. |
|
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. |