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
Si