Formatting field ( urgent !!!)

[2006 IR Open Dicussion]

By: ntc2000 - ntc2000

Formatting field ( urgent !!!)

2006-01-24 19:18

I need to list out the amount of the product in the jasper report (using Ireport GUI)....

 

When i list out the amount $F{AMOUNT} by using pattern as #,##0.00..... then its list out the amount and comma as separator.....

 

The problem is when he amount equal to 0 or amount less then thousand, then its didnt show the xxx.00.....

 

For example:

in report what I want

0 0.00

150 150.00

150.5 150.50

1,200.00 1,200.00

 

How can i do that???

Thank.....

 

 

 

 

By: Ionut Nedelcu - ionutned

RE: Formatting field ( urgent !!!)

2006-01-25 01:03

This is not a JasperReports problem. The library uses standard JDK formatting rules. In this particular case, the standard formatting rules described in java.text.DecimalFormat are used. Check the JDK javadocs.

 

Ionut

 

 

 

 

By: ntc2000 - ntc2000

RE: Formatting field ( urgent !!!)

2006-01-25 19:28

Then is there any way to solve this problem??

 

Thank...

 

 

 

 

By: Teodor Danciu - teodord

RE: Formatting field ( urgent !!!)

2006-01-26 00:50

 

Hi,

 

Could you post the JRXML snippet with the

text field that poses this problem?

Is there only one text field that has the

problem or there are some that work and

others that do not work?

 

Normally, this pattern you mentioned should do

the trick. We are not doing anything special

and use a DecimalFormat class behind the scenes

with the exact pattern you specify in the "pattern" attribute of the text field.

 

Thank you,

Teodor