I am trying to filter two columns so that if both columns have any combination of blank and zero for a given row, that row is filtered out. So both could be blank, both could be zero, one could be blank and one could be zero.

Is this code correct?

Dim LYFilterCondition As New FilterCondition
Dim TYFilterCondition As New FilterCondition
LYFilterCondition = New FilterCondition(e.Layout.Bands(0).Columns(1), FilterComparisionOperator.Equals, FilterCondition.NonBlankCellValue)
e.Layout.Bands(0).ColumnFilters(1).FilterConditions.Add(LYFilterCondition)
LYFilterCondition = New FilterCondition(e.Layout.Bands(0).Columns(1), FilterComparisionOperator.NotEquals, "0")
e.Layout.Bands(0).ColumnFilters(1).FilterConditions.Add(LYFilterCondition)
TYFilterCondition = New FilterCondition(e.Layout.Bands(0).Columns(1), FilterComparisionOperator.Equals, FilterCondition.NonBlankCellValue)
e.Layout.Bands(0).ColumnFilters(2).FilterConditions.Add(TYFilterCondition)
TYFilterCondition = New FilterCondition(e.Layout.Bands(0).Columns(1), FilterComparisionOperator.NotEquals, "0")
e.Layout.Bands(0).ColumnFilters(1).FilterConditions.Add(TYFilterCondition)
e.Layout.Bands(0).ColumnFilters.LogicalOperator = FilterLogicalOperator.Or

My results look promising, but the data set is so large, it's hard for me to verify if this is correct. I do note that the 'LYSHIP' column has '(Custom') in its filter box and 'TYSHIP' has '= (NonBlanks)' in its, which gives me pause and makes me wonder if I have this wrong.

Thanks.