COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: peewan on 22 Nov 2019 11:45:39 AM

Title: Exclude check in prompt page
Post by: peewan on 22 Nov 2019 11:45:39 AM
I would like to create the prompt page with exclude (check) option, but i don't know how. Any helps?
Thank you a lot!

Title: Re: Exclude check in prompt page
Post by: BigChris on 25 Nov 2019 01:57:37 AM
Create a prompt page and have a text box prompt with multiple selections allowed. Then have a filter that has something like [Group] not in ?YourNewPrompt?
Title: Re: Exclude check in prompt page
Post by: dougp on 25 Nov 2019 10:42:59 AM
I think you need something like this:

[Group] #prompt('Operator_Group', 'token',  'in')# ?Group?

But I don't see a checkbox or toggle prompt available.  You'll want to use a value prompt that has only two static choices.
Also, why so many text box prompts?  Why not use one text box prompt with Multi-select = Yes.  Or, better yet, a value prompt so users can't fat-finger the values.
If you need a checkbox, you'll need to do this using JavaScript.

See attached report spec for an example.