SSRS Reports As User Interface

But there I was, a guy with just a little too much time on his hands, the ability to write a stored procedure, create a few tables, and a user interface that already contained all the information I needed. The missing piece was for me to realize one of those data sets in my report could pass parameter data into a stored procedure that would insert data, not select it, and that it would do this regardless of whether the report actually displayed anything from that data set or not.

Next week I’ll discuss in detail how this can be done within SSRS, and some of the creative uses I’ve found for using reports as a UI.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>