We need to replace null value with Ellipsis in Jaspersoft

[chaitanya.mamunuru]

Hello:

We need replace our null values in our jaspersoft report with Ellipsis, can someone please help me with that.

 

Thanks in advance.

[gabriel.nadoroski]

Hi,
So, you can use this:

<textFieldExpression>    <![CDATA[($F{Street} != null  ? $F{Street} : " " )+" - "+($F{Number} != null ? $F{Number} : " " )+" - "+($F{Complement} != null ? $F{Complement} : " ")]]></textFieldExpression>[/code]

I caught this of one part of a report I have in my system, it is like a IF, or TERNARY, if the field is different of null he print the field, else he print just a blanc space, you can do this with a variable (I guess), or change the blanc space for a other field or variable.

Hope this helps.

Gabriel Nadoroski