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.