COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognosun on 12 Jan 2016 08:15:24 AM

Title: Drop down prompt
Post by: cognosun on 12 Jan 2016 08:15:24 AM
Hi,

I have a prompt named COUNTRY.

1) My requirement is...the prompt should appear in the prompt page as : +COUNTRY

2) If the user clicks on + sign it should get drop down displaying country names with check boxes like


+ Country

  USA
  CANADA
  UK

We are using relational model, can you tell me how to achieve this...

Many thanks in advance
Title: Re: Drop down prompt
Post by: BigChris on 12 Jan 2016 08:27:43 AM
Sounds like a normal value prompt to me, with the exception of the + sign. You choose what format the prompt should be in, list box, drop down or check box (depending on whether you're looking for a single choice, or allowing multiple choices).
Title: Re: Drop down prompt
Post by: cognosun on 12 Jan 2016 08:49:58 AM
yeah...any idea like how to bring + sign...and use it as drop down.
Title: Re: Drop down prompt
Post by: BigChris on 12 Jan 2016 09:50:32 AM
Nope - you might be able to do something with bespoke Javascript, but I wouldn't know how to do that. The normal down arrow works pretty well, and everyone knows how to use that...
Title: Re: Drop down prompt
Post by: okh310 on 12 Jan 2016 09:53:22 AM
You can use a value drop down prompt.  And designate the "HEADER TEXT" property to say something like "+ COUNTRY".
Title: Re: Drop down prompt
Post by: sdf on 13 Jan 2016 11:16:26 PM
or is it possible for you to use tree prompt instead?
try to have hierarchy for Country in your FM.
Title: Re: Drop down prompt
Post by: Gopinath on 19 Jan 2016 04:19:06 AM
Hi Cognosun,

Refer the attached image. You need to use 4 HTML items, i have included the code for each HTML items in the image.


Thanks,
Gopinath