Remove entire row when one column is null

[david.tessierlive.com]

How do I remove an entire row when one column is null? 

My table has ID, info1, info2, info3, total(sum of 1,2,3)

ID will always have a value, but when the total column is null, I want the entire row to be hidden. 

I have tried setting "Blank when NULL" on the total cell, but that only hides the one cell... I want to hide the entire row when total cell is null. 

[javier.ggi90]

There is a property named as "Remove line when blank", check it so it is true.

If that does not work you can try to modify your query for the report so that you have a condition as follows:

        WHERE (info1 + info2 + info3) IS NOT NULL

Cheers,

Javier

[david.tessierlive.com]

@Javier.ggi90, I have already set that property as well. The row still show s up. The column reads "null" though, so maybe jasper doesn't actually think it's null.... I think the ruery I run for this report is passing a string of "null". How can I resolve that?

[javier.ggi90]

If you still see "null" even though the "blank when null" property is set, then you probably have a "null" string. Then you can try setting the condition as: WHERE total != "null"