patternsqlMinor
Can SSRS used to Update or Modify data tables?
Viewed 0 times
ssrscantablesupdateuseddatamodify
Problem
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:
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:
- madeiradata
- sqlservergeeks
- experts-exchange
Solution
If Madeira Data shows you how to do it, then I think it's safe to say:
-
It's possible.
-
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.
-
It's possible.
-
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.
Context
StackExchange Database Administrators Q#200367, answer score: 5
Revisions (0)
No revisions yet.