How do I set a Default Value of "Select All" in SSRS?
reporting-services, sql-server-2008
Solution
With the help of this other question, I got this fixed (thanks Jeroen) , just needed to make the "Default Values" the same as Available val.'s:
Problem
Possible Duplicate: Select All as default value for Multivalue parameter I have a drop-down parameter in SSRS that gets populated via the following query: ``` select ID, name from accounts where LK_RecordStatusID = 1 order by Name asc ``` I need it to be a multi-value parameter. In SSRS, I can do this. However, I can't also let it be a null value . However, I'd like it to have a default-value of "Null", that corresponds to the "Select All" choice. I looked online and I see something about using -1 as an alternative to null? It seems I can't specify a null value . Any tips appreciated, thanks