COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: alex_ on 28 Nov 2012 07:15:56 PM

Title: How to make filter which work with 'OR'?
Post by: alex_ on 28 Nov 2012 07:15:56 PM
Hi all,
I have five prompt detail filters. 
Prompt detail filter use Operator 'AND', I need to filter data with Operator 'OR'. How to configure filters so that they should work with 'OR'?

Thanks.
Title: Re: How to make filter which work with 'OR'?
Post by: HalfBloodPrince on 29 Nov 2012 01:32:57 AM
Please provide more details like what is ur condition , some data if possible
Title: Re: How to make filter which work with 'OR'?
Post by: MFGF on 29 Nov 2012 04:25:28 AM
The simple answer is to combine all five of the separate detail filters into a single detail filter expression, with each component separated by an OR operator.

As HalfBloodPrince says, if you can provide some detail about the expressions you are using, we might be able to suggest a single expression that will give you what you need?

Regards,

MF.
Title: Re: How to make filter which work with 'OR'?
Post by: alex_ on 30 Nov 2012 11:37:48 AM
Sure.

In one filter I put the all prompt values and everything work properly.

Thanks :)