JasperReports: default value instead of 'null'

Is there any way to set a default value to a开发者_开发知识库 field in a report? I have a lot of String fields in a report and would like them to display "0,00" when they're null.

---

Supposing the field name is "value", in the "Text Field Expression", write:

($F{value} != null) ? $F{value} : "0.00"

---

You can also select "Blank when null" in the properties of the text field if you want that. Other options are more flexible but this does the trick very quick and easy.

---

medopal's answer is good, but 2 additions:

1) You can make the syntax shorter:

($F{field_name}) ? $F{field_name} : "0.00"

2) Make sure your "else" data is of the same class as the field's value, otherwise you'll get errors when it tries to coerce numbers into string, etc. etc. This was something that, as I started out, I mixed up.

---

Did you try set a pattern in the text field?

If you are using iReport this can be found in the properties for the text field in the Text Field Properties section.

Try something along the lines of ###0.00 to represent 1234.56, which would always display 0.00 even if it is null.

---

This is the easiest way is to use Coalesce() or NVL() function of database in your data-source query to restrict null data on your report.

But it depends on if you are allowed to change the datasource query or not. If not then you can go for other solutions provided in previous answers.