Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: gatorfe on 28 Oct 2009 02:56:48 PM

Title: Filter Expression Help
Post by: gatorfe on 28 Oct 2009 02:56:48 PM
I am trying to create a filter were I can exclude certain products from showing on my report.  The products all end in "LLL". Any suggestions would be greatly appreciated.  Thanks
Title: Re: Filter Expression Help
Post by: whastings on 28 Oct 2009 04:01:03 PM
when defining a filter, one of the available Operator Functions (e.g. =, <>, etc.) is "ends with", so you should be able to say "not ends with".
Title: Re: Filter Expression Help
Post by: admin_cog on 30 Oct 2009 01:29:20 PM
can you try using substr..
Title: Re: Filter Expression Help
Post by: Gopinath on 02 Nov 2009 09:42:29 AM
try a filter expression like

[Products] Like '%LLL'
Title: Re: Filter Expression Help
Post by: kerryn on 02 Nov 2009 11:36:47 AM
He wants to exclude so use [field] not like '%LLL' assuming the database is oracle of course.
Text only | Text with Images