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

Conditional Format Prompt Page Check bog Group

Started by Cape Cod Gunny, 29 Aug 2019 01:58:01 PM

Previous topic - Next topic

Cape Cod Gunny

I have successfully created a prompt page with a Multi-Select Check box group. It works like a champ. Now I'm trying to take it to the next level using conditional formatting on the prompt page. The check box group contains 20 items. 7 of these 20 items are the most popular. I'd like to display these 7 most popular using red foreground color and leave the remaining choices the default font color of black.


How do I do this?
Michael Riley
Marine Corps Gunnery Sergeant (Retired)

"We may never pass this way again!"

Cape Cod Gunny

I had no idea you could wrap <HTML Item>'s around prompt values. It doesn't work with Internet Explorer. Chrome and Firefox work great. I want to give a shout out to dougp from Stack Overflow for the solution.

https://stackoverflow.com/a/57779628/195983

Michael Riley
Marine Corps Gunnery Sergeant (Retired)

"We may never pass this way again!"

Francis aka khayman

pardon me i've had too much coffee today so i am overthinking...

how about creating two sets of multi select prompt? the first set are the 7 most popular so you can format the color for these. the second set are the rest of the prompts.

you can either merge/union the selected values in the two parameters (can one parameter be used? not sure if its possible)

or you can filter using [column] in ?parameter1? or [column] in ?parameter2?