COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: hana00 on 15 Mar 2017 01:43:57 AM

Title: Case in multiselect optional PROMPT (if value is null then..)
Post by: hana00 on 15 Mar 2017 01:43:57 AM
Hi all!

I have some problem with adding case to filter using prompt, maybe somebody had same issue like mine, I looked a lot in internet but all fixes didn't worked..

I have multiselect and optional prompts and I would like to create in filter on query, which will have logics like this:

when ?Prompt 1? is null  then  [Data Item] in ?Prompt 2?
when ?Prompt 2? is null then do nothing

Something like this.

Thanks for help in advance!