开发者

SSRS SELECT ALL emulation in ASP.NET Dropdown List

开发者 https://www.devze.com 2023-03-23 14:15 出处:网络
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.

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?

SSRS SELECT ALL emulation in ASP.NET Dropdown List


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


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

0

精彩评论

暂无评论...
验证码 换一张
取 消