Chart Legend displays null values

[gr4nt4]

I have an SQL that returns null values but the chart fails to compile due to a 'nul pointer Exception' so I've used the code

$F{PRODUCTDESC}==null?"":$F{PRODUCTDESC}

However this now produces an legend segment that has no description in (see graphic)

I'm looking to do one of the below:

1. Remove the single segment from the legend

2.Change the segment color to white and the segment border to white

3. Have the chart compile correctly even with a nul value.

[mdahlman]

If you don't want rows with a NULL product description to show up in the report, then the usual choice is to modify the SQL query so that it does not return them. Is that an option in your case?

 

Either like this:
where PRODUCTDESC is not null

 

Or like this:
coalesce(PRODUCTDESC,'No Desc')

 

Regards,
Matt

[gr4nt4]

Hi Matt

 

Thanks for the reply, unfortunatly in this case its not an option.

[bklawans]

Do you want the nulls in the chart but with a different label, or do you want them filtered out? If you want to filter them out completely but can't do it in the query, use the filterExpression to skip rows that are null. The expression can be "new Boolean($F{field} == null)". In iReport there is a button on the query screen that lets you set the filter.