Kbase P7820: Actuate: Formatting of data fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/08/2003 |
|
Status: Unverified
GOAL:
Formatting of data fields
FIX:
Formatting of Fields
Irrespective of the Format in the Database ,
Actuate can alter the format of fields as per the user's
request.All the Data Controls in Actuate have a
Format Property.One Can Access the format property
by Double Clicking the Field in the Design Editor.
Eg : If The Number field has to displayed
as 999,999,99.00
Then the format property would have to be changed
to ###,###,##.00
If the Date field has to be displayed as year-date-month
then the format would be "yyyy-dd-mm"
There is yet another way of specifying
negative or positive numbers.
Eg: If the field has negative ,positive or zero
returned then the format of the field can be
changed to #,###;(#,###);"-"
the above format would return
Positive Numbers --- 9,999
Negative Numbers --- (9,999)
Zero --- -