COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: icarder on 14 Jan 2014 03:34:59 PM

Title: Simple detail filter Contains/or
Post by: icarder on 14 Jan 2014 03:34:59 PM
Hello,

I'm struggling with something that I'm sure should be really simple.  All I'm trying to do is filter on a data item(Personnel Employee Type Code) if it has an A or a B.  I keep getting various parsing errors.  Even using the select multiple values button in the detail filter expression, I still get the errors while trying to validate.  Here's what I tried:

[Personnel Employee Type Code] = ('A', 'B')

Any help would be greatly appreciated. 
Title: Re: Simple detail filter Contains/or
Post by: charon on 14 Jan 2014 03:54:01 PM
Hi icarder,

you might wanne try
[Personnel Employee Type Code] in  ('A', 'B')

or
[Personnel Employee Type Code] in ('A'; 'B') (in europe there is used a semicolon.

GL and cheerz :)
Title: Re: Simple detail filter Contains/or
Post by: icarder on 15 Jan 2014 08:09:12 AM
Charon,

That worked perfectly.  Thanks for helping a cognos simpleton!
Title: Re: Simple detail filter Contains/or
Post by: charon on 15 Jan 2014 09:37:42 AM
You are welcome sir  :D