Skip to main content

BI in SQL vNext

New

Improve parameter passing in SSRS

Vote (31) Share
Paul Turley's profile image

Paul Turley on 05 Feb 2015 01:44:32

Parameters are the key to building interactive reporting solutions but complex report designs can become difficult to maintain. Let's say that I have ten items on a dashboard style report that pass all the parameters back to the same report (which is necessary to maintain the state of previously-selected parameter values)... Now I add one more parameter to the report and I have to find every item with an action to add that parameter. If there were some kind of a parameter collection object, similar to the property bag in old VB or the Request/Response/Application/Cookies objects commonly used in ASP.NET; this could be used to add the new parameter to the collection and simply pass the whole thing as an object to maintain the state of previously selected values. I have several specific thoughts and examples to share on this subject.

Comments (1)
Paul Turley's profile image Profile Picture

af0019aa 9a7e-4776-9021-7b1171cd13bc on 05 Jul 2020 21:57:50

RE: Improve parameter passing in SSRS

You got my vote Paul. Another very similar scenario is a "Report Pack" style with multiple sub-reports. Many of them will share the same set of parameters.