COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 16 Apr 2014 04:57:48 AM

Title: what logic need to be written in order get the specified value
Post by: inu on 16 Apr 2014 04:57:48 AM
Hi
I have created one prompt page displaying the country data item values. if i select a country value, it displays the corresponding values correctly.
now In addition to this, i created one static choice 'ALL' to display in the prompt page. and created the filter such as
country_data_item=?parameter? OR 'ALL'='ALL' to make the value true.
Now if i select the all in prompt page , it displays all country values properly, but if we select other value say 'India' , yet displaying all the country values.
How to handle this situation, please tell the logic , what logic should i write in filter expression, to meet the requirement.

Regards
Inam
Title: Re: what logic need to be written in order get the specified value
Post by: qvixote on 16 Apr 2014 07:13:44 AM
Hi!

As I see it, only using logic, that expression will always evaluate as TRUE, because no matter what choice you pick in the prompt page, 'ALL' string will be always equal to 'ALL' string.

Regards.
Title: Re: what logic need to be written in order get the specified value
Post by: navissar on 16 Apr 2014 08:03:59 AM
country_data_item=?parameter? OR ?parameter?='ALL'