COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: asini on 14 Nov 2008 04:24:50 PM

Title: how to set default values in Value Prompt
Post by: asini on 14 Nov 2008 04:24:50 PM
Hello All,

Can any one please give me an idea,

in my report i have a value prompt (multi selectable countries list)
this is manually created prompt (inserted one prompt page, then inserted value prompt from toolbox)

when i run the report this prompt shows available countries (what ever exist in Database could be 20 or 50 .....)
in the list when i select values & click finish it works fine

how can i set default values (when we run the report USA & CANADA needs to be select default)
because almost 95% of our customers will run based on only US & CANADA countries

i did, setup valueprompt Default Select Value,  but it is useless, it doesn't work

Please Help Me

Thanks in advance

asini
Title: Re: how to set default values in Value Prompt
Post by: lindero on 17 Nov 2008 03:26:21 AM
it will work when you set the default value to the useValue of the prompt. e.x.

You have country name and country code.

useValue: product code (1/2/3/4/5)
displayValue: product description (Germany/US/Canada/France/Italy)

Now you want to set US and Canada as default selection:

default: 2 and 3

hope this helps and cheers
Title: Re: how to set default values in Value Prompt
Post by: vijayab on 17 Nov 2008 07:38:34 AM
Select The Prompt
go to the Property Pane---->select the option static choices in that add the Values as Use and Display ...

This way  u will get the values in ur report prompt .....

hope it will help u :)
:)
vij