CODEWITHSUNDEEP
asp.netreporting-servicesssrs-2008reportviewer
Santosh Chandavaram
Santosh Chandavaram

Reputation: 2500

SSRS SELECT ALL emulation in ASP.NET Dropdown List

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

Upvotes: 1

Views: 880

Answers (2)

Muhammad Umair Tariq
Muhammad Umair Tariq

Reputation: 31

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

Upvotes: 1

codeulike
codeulike

Reputation: 23064

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

Upvotes: 0

Related Questions