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
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.
country_data_item=?parameter? OR ?parameter?='ALL'