Field format changing on its own.

[kwalters135]

I am using CR XI R2 on Win XP.

In a detail section of a report, there are numeric fields whose number format will change on its own.

The numbers are formatted as (1234.00). However, when I close the report and reload it in crystal, the number format will change to custom. Within custom, it is set to show negative numbers with a "-" instead of parens.

Not sure how or why this is changing on its own.

 

[Madawc]

Each PC using Crystal can have its own defaults. YOu'll find them at File > Options > Fields.

You can show the value via a formula field and use ToText to format it. It takes a bit of time but can be relied on not to change.

if {value} < 0
then "(" & ToText({value}, 2) & ")"
else ToText({value}, 2)

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10