If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Exclude check in prompt page

Started by peewan, 22 Nov 2019 11:45:39 AM

Previous topic - Next topic

peewan

I would like to create the prompt page with exclude (check) option, but i don't know how. Any helps?
Thank you a lot!


BigChris

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?

dougp

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.