COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: everlearner on 16 Jan 2013 06:38:20 AM

Title: how to avoid the some values in a value prompt?
Post by: everlearner on 16 Jan 2013 06:38:20 AM
Hi Gurus,

I have defined a value prompt for a column, that column has 17 diff values. but i have to display only some values
for the selection. how to avoid the unwanted values in the prompt???

Thanks in adv
Title: Re: how to avoid the some values in a value prompt?
Post by: charlie on 16 Jan 2013 06:49:51 AM
You could use a entirely different query for the value prompt. You could filter out the values you need.  ;)

Cheers
Charlie
Title: Re: how to avoid the some values in a value prompt?
Post by: MFGF on 16 Jan 2013 09:38:09 AM
Yep. As Charlie suggests, just add the relevant filter to the query used to retrieve your prompt values.

Cheers!

MF.