“Select All” not available when you try to preview a report in Report Designer after you install SQL Server 2005 Service Pack 1
Today I had to change an existing report, created using SQL Server 2005 Reporting Services. When I originally created this report a few months ago, there was no problem viewing these reports in the Preview of the Report Designer.
But now the “Select All” was not available anymore in the list of values for parameters defined as “Multivalued Parameters“.
The first possible reason I could think of was SP1 for SQL Server 2005 which was not installed yet when the reports were created.
After some searching on the support site of Microsoft, I found this KB
It’s not available for download, but you can contact Microsoft Product Support Services to obtain the hotfix or wait for SP2.
