SSRS SELECT ALL emulation in ASP.NET Dropdown List

1
votes

I have a multi-value parameter for SSRS report.
This parameter being a multi-select will have SELECT ALL option that selects all values under the drop down list. Challenge is emulating the same using ASP.NET drop down list as parameter source. I will use reportviewer control just to render and display report but not to show parameters. Parameters come from ASP.NET page. How do I achieve SELECT ALL functionality in this case?

enter image description here

2
asp.netreporting-servicesssrs-2008reportviewer
do you want it to default to select all? Because in that case you can set the default values for the parameter (I would do this in BIDS). – ek_ny

2 Answers

1
votes

You can achieve this in query to retrieve dummy record and do UNION. Just do a very simple thing showed below.

Select 0 as ID, "(Show All)" as Name
Union
Select Id, Name from MyTable
0
votes

You could use a jquery widget to do something like this. For example see Eric Hynds jQuery UI Mutliselect: http://www.erichynds.com/jquery/jquery-ui-multiselect-widget/

It has a 'select all' option