COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: wbarry123 on 25 Oct 2010 03:34:15 PM

Title: Suppress row if it contains a null vlue
Post by: wbarry123 on 25 Oct 2010 03:34:15 PM
How do I suppress an entire row in a list report if the row contains a null value in one column.  I am using Cognos 8.3 on sql server.
Thanks in advance!
Title: Re: Suppress row if it contains a null vlue
Post by: wbarry123 on 25 Oct 2010 04:43:09 PM
This was actually quite simple.  I just st up the null value field as a filter:
[data item] is not null