Hi Jorge,
Huray, huray!!!!!!! I found a problem. It was a space @Z$ 999,999,999 (I forgot the space at first). I figired this by comparing with another report.
I'm happy again :)
>Odd, that would drive me crazy too, if it's any consolation :)
>
>>Hi Jorge,
>>
>>Tried that :( I would not say it's driving me crazy otherwise...
>>
>>Still doesn't do what I want!!!!!!!
>>
>>>Hi, why don't you just format the field in the report with $999,999.99 or whatever fits your needs, this way it will work every time regardless of regional settings.
>>>
>>>>Hi everybody,
>>>>
>>>>I'm designing a report. I added fields in the body section, say, mortgage. I set format to currency and display blank if 0. I want it to be $123,250 (, separates thousand). Instead I have $123250.000000000 I checked my region settings, they are ok. I tried set decimal to 0 and set fixed on/off. Nothing helped. What else could it be?
>>>>
>>>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog