multi select in dropdown value prompt

[s.rajesh]

Hi all,

I want  to have a multi select dropdown prompt where values are displayed only on click on button in the side as in excel.Normally we can select single value in drop down but my client requirement is that he has to get multipul selection in dropdown based on that values should be filter .

thanks in advance.

Rajesh.

[MFGF]

Hi,

A "Drop down list" will only permit single items to be selected. You will need to change the "Select UI" property to be a "List box", Set the "Multi-Select" property to "Yes", then add a Prompt Button to the report with a "Type" property set to "Reprompt". You can relabel the button by dropping a text item on top of it. You will also need to make sure that the underlying filter is using an "in" operator rather than "=".

Regards,

MF.

[s.rajesh]

Yes you are right "Drop down list" will only permit single item to be selected.I would like to know  is there any javascript to achieve this  multipul items selection in drop down list.please help me .

Thanks in advance ,

rajesh

[MFGF]

Why would you want to try to jump through these kinds of almost impossible hoops when a List Box does the job with no extra coding? List boxes actually take less interaction because there is no click required to show the prompt values as with a drop down list.

Just a thought.

MF.

[venkys4u]

I think i saw some articles likes creating reports similar to your requirement.. Wil update if i could see the article from the history of my office machine

[mahgar]

Hi All,

I have the same problem and already applied the same solution and it works fine. But the problem is when I select 2 values in the 1st prompt the rendered prompt is not showing up.

Note:
Product Category has 4 values and each values has an equivalent Type of Product.

Can you please share if you have any solution on this scenario.

TIA!

[Raghuvir]

i agree with MFGF.

its an inbuilt feature in cognos, so why to do coding when the option is readily available.

Regards