Print Page - Filter Out Text

Title: Filter Out Text
Post by: KEKeogh on 09 Nov 2009 01:25:16 PM

I'm sure I'm missing something simple but I just can't see it.

I have a a report that I want to pull all items where the Desription field does NOT begin with "FYI".

I was thinking [Description] is missing 'FYI' would work but it didn't.

Thanks for the help
Kathie

Title: Re: Filter Out Text
Post by: Gopinath on 10 Nov 2009 02:39:38 AM

Hi,

[Description] NOT LIKE 'FYI%' should work.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: KEKeogh on 09 Nov 2009 01:25:16 PM