Caution with SQL Server 2012 SP1 CU4, Bug with nested multi-valued parameter
Last week at customer side we had some problems in SQL Server 2012 Reporting Services with nested multi-value parameter. A report that was working fine in SQL 2008 was deployed to SQL Server 2012 SP1 CU4. When trying to render the report or select values from a multi-value parameter that was depended on the choice of another parameter, this multi-valued one wasn’t selectable. It was greyed out. (see Screenshot)
When comparing the RDL-File between 2008 and 2012 there was no difference. So we decided to check the report in Visual Studio. But there it was working. Same thing for Report-Builder. The parameter could be selected and the report was rendering fine. By comparing the underlying data source query and the rendering behavior we found that the second query to get the values for the multi-value parameter to choose from wasn’t fired at SQL Server 2012 but SQL Server 2008.
Another test with SQL Server 2012 SP1 without CU4 was successful. The report was able to render and the query was fired against the SQL Server engine.
So is was clear. The CU4 was causing this unexpected behavior. Workaround for this BUG:
- Uninstall this CU and the report is useable again.
- Define a default value for the multi-value parameter. This might be difficult when the second parameter is depending on the selection of the first on (nested)
- Wait for CU5 which will fix the bug and with be released at the end of July.
After some research on the internet we found this link with further information.
Here you can find the RDL-File to reproduce the bug. (right click, "Save file as") Blog_Example.rdl
Here you can get the CU4. http://support.microsoft.com/kb/2833645
Feel free to ask, if you have further questions to this bug or need some assistance with the suggested workarounds.