COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gshilpa24 on 09 Jun 2008 12:55:36 AM

Title: Rows
Post by: gshilpa24 on 09 Jun 2008 12:55:36 AM
Hi,
Plz can anyone tell me how to delete the rows which are blank?
There are two col : Filenames , Tables . There are few filenames which are blank . ( No Filename )
I need to get the output where only there are names of filenames along with table names.

Please suggest .

Thanks in advance.

Title: Re: Rows
Post by: Gopinath on 09 Jun 2008 02:07:59 AM
Include a filter condition where [File Name]  Is Not Null
Title: Re: Rows
Post by: jahnavi on 10 Jun 2008 12:36:19 AM
use the filter to display [dataitem] is not null
Title: Re: Rows
Post by: gshilpa24 on 11 Jun 2008 05:13:35 AM
Hi ,
Thanks for the help .

Filter condition <> ' ' has helped to solve this.