I would like to suppress a row of data if each of my 5 currency columns contains a zero. An example of 1 record is below:
Code:
Col 1, col 2, col 3, col 4, col 5, col 6, col7, col 8
Smith, 2008, qtr4, 0, 0, 0, 0, 0
So if columns 4 through 8 all contain zeros then I don’t want this record to appear in my report. I am not sure if this is even possible as I have been unable to find any documentation...