0 Replies Latest reply: Jul 31, 2013 7:32 AM by Merina Prema RSS

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

      Hi,

       

      I have a straight table as shown below.

       

      fig.1

      Dim1Dim2Date
      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

      Dim1Dim2Datetest date
      Abi 2/2/20130
      Christy -1
      Ronald 6/6/20120
      Venkat 5/10/20130
      Jim -1
      Jeremy -1

      and then I checked Supress Zero Values in presentation tab.

      the result i got is,

       

      fig.3

      Dim1Dim2Datetest 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.