Number pattern doesn\'t show

[mickyrox]

Hi

I'm working on a report and its running smooth so far.

However i'm a begginer and have no experience in java so i need to find a way around this.

I need to display a field as a number with 2 digits after the decimal and a thousands seperator.
It should look like 12,345.60
So i set the pattern accordingly.

the expression in my text field is: ($F{BigDecimal1}.plus($F{BigDecimal2}).divide($P{Integer},2))

The arthematic is correct, but when my field displays i see something like.

12345.6 instead of 12,345.60. I'd appreciate if you could point out where i'm going wrong.

Kindly ask for any specific information.

Thanks in Advance
micky
 

[slow]

try to use this expression in the pattern field of your bigDecimal textfield:

#,##0.##;-#,##0.##

 

give us feedback...

 

_________________________________________

if it works... give me KARMA points please!    : ) 
_________________________________________

listening:  Lamb - Gabriel

Post Edited by slow at 08/19/2010 06:59

[mickyrox]

Thanks!! Ploblem solved!!