web
You’re offline. This is a read only version of the page.
close
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.