How to display the "Unknown" text ?

[nikitha]

Hi,

I have a requirement to get the text "Unknown" when we get the null value for the field while displaying the records from database in detail section of jrxml template

Please help me to move forward.

Regards,

Naveen

 

 

 

[kenclark]

I think you can do it basically like this:

 

Create a static text element and set it to only print when the field is null using "Print When Expression".

 

On your text field, set it to print blank when null.

 

Put the two fields on top of each other.

 

Good luck,

ken

[hangman01]

You can create a Java String variable which you can fill using $F{your_field}==null?"Unknown":$F{your_field}

if your_field is not a String the toString() method can be used to make it a string. This will simplfy the report since you will not have text_fields stacked on top of other text fields.