COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Cape Cod Gunny on 29 Aug 2019 01:58:01 PM

Title: Conditional Format Prompt Page Check bog Group
Post by: Cape Cod Gunny on 29 Aug 2019 01:58:01 PM
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?
Title: Re: Conditional Format Prompt Page Check bog Group
Post by: Cape Cod Gunny on 04 Sep 2019 11:09:09 AM
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 (https://stackoverflow.com/a/57779628/195983)

Title: Re: Conditional Format Prompt Page Check bog Group
Post by: Francis aka khayman on 10 Oct 2019 01:38:45 PM
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?