Hi i have a chart where i want to show a label in this format "R$1.235,00" .At the chart i have a field $F{soma} that is a BigDecimal. If i print just $F{soma} i'm getting something like: "1.235,00".And like i said i need it like "R$1.235,00".
I've tred this:
new java.text.DecimalFormat("R$ #,##0.00").format($F{soma})
But then i get this exception:
java.lang.String cannot be cast to java.lang.Number
How can i solve that, can anyone help?Thanks.
MYsql database and the type of soma is in java class is Bigdecimal, and at the database it says decimal(19,2).
I was told that printing just $F{soma} it shouldn't format the soma as "1.235,00". So i gues it have something to do with my database.