all groups > sql server reporting services > december 2006 >
You're in the

sql server reporting services

group:

SP1 MultiValue Parameter Select All Alternative


SP1 MultiValue Parameter Select All Alternative SimonDev
12/27/2006 6:39:01 PM
sql server reporting services: Hi

I guess the SP1 MultiValue Parameter great disappearing Select All option
has been done to death on this news group by now. That isn't exactly my
problem but it's related.

I've actually solved the basic problem, thanks to suggestions in Brian
Welcker's blog
(https://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx) and the Data
Points article in the June 2006 MSDN Magazine
(http://msdn.microsoft.com/msdnmag/issues/06/06/datapoints/default.aspx#S5).

My question is: Does anyone know how to make a custom "Select All" in SP1
behave a bit like the old Select All that was removed? Specifically, if a
user selects my custom "Select All", how can I de-select any other items in
the parameter list the user may have previously selected? Also, if the user
selects another item in the list how can I de-select the "Select All" option
if it is already selected? Is there some parameter list click event I could
handle that would allow me to de-select items in the parameter list when a
particular item is clicked?

This is the query I use to populate the parameter list:

SELECT warehouse_id,
descr
FROM warehouse
UNION
SELECT 'ALL' AS warehouse_id,
'[All Warehouses in Selected Region]' AS Descr
ORDER BY descr

Cheers
Re: SP1 MultiValue Parameter Select All Alternative SimonDev
12/27/2006 8:35:00 PM
Thanks Jeje.

Cheers
Si


[quoted text, click to view]
Re: SP1 MultiValue Parameter Select All Alternative Jeje
12/27/2006 10:44:28 PM
if you can wait a month... the SP2 will offer the select all.
else use the reportviewer webcontrol.

to deselect anything else the select all is not possible until you create
your own rendering application.


[quoted text, click to view]
Re: SP1 MultiValue Parameter Select All Alternative Bruce L-C [MVP]
12/29/2006 9:13:09 PM
Also there is a hotfix for this (I have it installed and working for quite
awhile now). The hotfix brings back the old functionality (prior to SP1).


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button