Tuesday, January 2, 2007 8:49 PM tonyrogerson

Reporting Services (Select All) flip flop in SP2 - it makes me mad, introducing/changing stuff via service packs...

You can have multi-valued parameters in SQL Server Reporting Services, on selecting the mulitple options a CSV list is passed to the stored procedure or formed for the SQL.

When you choose (Select ALL), all the parameters in the list box are generated, so if you have 100 values in the list box then you get 100 on the CSV and passed to your proc.

On SP1 this behaviour isn't there, you code the Select ALL mechanism yourself and have full control.

Low and behold, we have a change in behaviour back to the original RTM (lot of good for people like me who have developed their stuff on SP1) as part of the move to Service Pack 2. This is crazy on so many fronts; anyway - I want an option in the RDL that allows THE DEVELOPER to choose if I want a Select All or not.

Vote with me here if you agree: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=249227

Annoyingly Microsoft have 'postponed it for a future version' but personally I don't think that is good enough.



Filed under:


No Comments