By user129291


2018-03-15 14:28:58 8 Comments

We all know SSRS (SQL Server Reporting Services) is to read data.

However, can SSRS be utilized to update rows or insert rows, and should it?

I am seeing resources here, where you can take user input parameters and update rows. Just inquiring if it is advisable/allowed to use that tool in such a way. Does Microsoft have anything against doing that?

Resources stating this:

http://www.madeiradata.com/using-reporting-services-as-your-software-frontend/
http://www.sqlservergeeks.com/sql-server-using-sql-server-reporting-services-to-manage-data/
https://www.experts-exchange.com/articles/8737/SSRS-can-be-also-used-for-user-inputs.html

2 comments

@Jerb 2018-03-20 16:37:22

I've used SSRS for a subset of this kind of activity.

It's not great for using as a full-on data input program for obvious reason, but there's no particular problem with running insert/update/delete statements inside datasets.

What I've tended to use it for is more "clicky" kinds of updates. Where clicking on a hyperlink within a report causes something to happen - be it insert something in to the database, update a value somewhere, etc. And the activity that happens is controlled by the hyperlink passing in the various parameters to control that.

I've tended to use a report where the hyperlink runs a new instance of the same report, but controls what gets updated by passing in new parameters. Mainly so that all the code is in a single report.

I've made a quick demo report to demonstrate the technique in action, if that'll help? Available at: https://github.com/JerBoon/updating_with_SSRS

You can do quite sophisticated stuff within the confines of this technique, but it's definitely not a data entry portal for entering entire rows of data. I'd be interested to hear if anyone's really used it for that in earnest.

@Max Vernon 2018-03-15 14:46:22

If Madeira Data1 shows you how to do it, then I think it's safe to say:

  1. It's possible.
  2. It can be made to work, as evidenced by this paragraph from them:

    It’s especially good when your organization doesn’t have skilled programmers that can create a pretty-looking graphical user interface (GUI). Or when there are budget and / or time restrictions.

Deciding if this kind of setup will work for you is entirely your decision.


1 - Guy Glantser and Matan Yungman are very highly regarded members of the SQL Server ecosystem, and are principals of Madeira Data

Related Questions

Sponsored Content

1 Answered Questions

1 Answered Questions

[SOLVED] Give users permission to read subsets of data in tables in SSRS

2 Answered Questions

[SOLVED] SSRS: First report is slow: Reloading Appdomain

2 Answered Questions

[SOLVED] how to add a data source to SSRS - reporting services 2014?

2 Answered Questions

[SOLVED] Updating data from a report: any potential pitfalls?

  • 2012-09-10 07:46:43
  • Jeroen
  • 1570 View
  • 5 Score
  • 2 Answer
  • Tags:   sql-server ssrs

Sponsored Content