Using substring to convert number to text.

[DavidT_UK]

Hello,

I've got a report that when run outputs a number 1 (it's a string field) but I need it to actually display as 'INV' (the 1 means  invoice in the application).  I'm fairly new to Jasper Studio so I'm having trouble on what I suspect is a very easy variable.

Can anyone help?  I've tried looking for it but everything being posted is overly complicated and much more than i need.

Thanks.

 

 

[Duggu09]

Hi

If your output '1' is from a field  then you can use the Jasper if-else expression. Below is the example

Ex: $F{FieldName}.equals("1") ? "INV" : $F{FieldName} 

You can provide anything in else statement as per your requirement.

 

 

Thanks!

 

[DavidT_UK]

Thanks Duggu, that is perfect!  Much appreciated. 

[sanbez]

Duggu09's answer is great.
A small correction:
Use
Ex: "1".equals($F{FieldName}) ? "INV" : $F{FieldName} 

to avoid a potentional NullPointerException

[DavidT_UK]

Thanks everyone, that's sorted the issues I was having and it's looking fine now :D