Supressing Null value in straight table while giving alternate row color.

[#1]

Hi,

I have a straight table as shown below.

fig.1

Dim1	Dim2	Date
Abi		2/2/2013
Christy		-
Ronald		6/6/2012
Venkat		5/10/2013
Jim		-
Jeremy		-

Now i want to show only the rows that has no date(i.e date is null)

I added an expression like (if (len(date)=0,1,0)). I got as shown below.

fig.2

Dim1	Dim2	Date	test date
Abi		2/2/2013	0
Christy		-	1
Ronald		6/6/2012	0
Venkat		5/10/2013	0
Jim		-	1
Jeremy		-	1

and then I checked Supress Zero Values in presentation tab.

the result i got is,

fig.3

Dim1	Dim2	Date	test date
Christy		-	1
Jim		-	1
Jeremy		-	1

Now, the problem is when I tried to give alternate row color using the expression if(even(rowno(total)),rgb(255,255,0)),again the rows with date are coming up. like the second fig.I want the rows in figure 3 to be colored alternatively not fig 2.

Any idea on this is highly appreciated.

Thanks,

Prem.