Print N/A when field is NULL

Before building the data filed in the report you may need to check whether the data filed is empty or null while show the data.

By using the below expression you can able to achieve the result, for the my case I need to check whether the field is empty or not, if empty I need to pass the value as ‘NA’. Based on ‘NA’ values I can customize the backend store procedure to bring up the required result.

<![CDATA[$P{var_Sequence_Number}.equals( "" )? "NA" : $P{var_Sequence_Number}]]>

Thank You