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

How to display except prompt selection items

Started by Chandrasekar, 28 Oct 2014 08:49:51 AM

Previous topic - Next topic

Chandrasekar

Hi Gurus,

I have a scenario to display the except prompt selection items. For example: i have values in value prompt like,

                             item 1(Prompt selectd)
                             item 2(Prompt not selected)
                             item 3(Prompt Selected)
                             item 4(Prompt not selected)

I have to display the item 2, item 4 names in report page. Is it possible, how to solve this?

Thanks & Regards,
Chandrasekar.

cognos810

Hello Chandrasekar,
Do Item 1 through 4 come from a query? If so, create another query for display purposes and set a filter on it saying Item not in <your selections>. Then associate a list/repeater etc to display the values from that query.
If they are static texts you can always "force" it to come from a query using SQL objects that has an SQL like this:
Select distinct 1 from <sometable>
union all
Select distinct 2 from <sometable>
union all
Select distinct 3 from <sometable>
union all
Select distinct 4 from <sometable>