SSReportingServices 2005 - Data Manipulation

Question

SSReportingServices 2005 - Data Manipulation

Lawrence-136504

SSC Eights!

Points: 961
More actions
September 17, 2007 at 11:52 am

#177483

Hi All,
I developing a SSRS 2005 Report and I would like to update data back to table via the Report. If the column has a name of TestName, I would like to update "TestName" to John Doe.
I haven't found a lot of documentation online for this.
Your help will be greatly appreciated.
Thks! L

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

dwall-374293 Valued Member Points: 61 More actions · Answer 1

Not sure I completely understand so I'm going to ask some questions.

From how I read the question, you want to take a SSRS report, replace anything in column 'x' that says "Testname" with "John Doe" and push those values back into the table that the report came from?

What is the dataset that your report is based on (table, view, stored procedure, something else)?

Would it not be better just to do something like an update query on the table, or is there some reason SSRS has to be involved?

smv929 SSCrazy Points: 2889 More actions · Answer 2

So where wil "John Doe" come from?

a) user entered parameter

b) another column of the same record (as dwall asks)?

I guess you would enter text in a text box, assign it's Navigation propterty so that when the user clicks that text box value, it passes the values to a procedure (Update) statement that is then executed. However, I'm having trouble with the details behind that.

smv929

Lawrence-136504 SSC Eights! Points: 961 More actions · Answer 3

Let's say there is a table called Employee. Employee table has columns as FirstName, LastName, Department, StartDate. I have a simple query for example select * from Employee . The first row has Albert Stone Engineering for the three columns. Would it be possible within a reporting services 2005 report that if you wanted to have a user select only the columns FirstName and LastName to modify there names and then update them by click an Update buttom of sort.

I know this is possible in a query and a .Net web page. Is this possible within a reporting services 2005 report from a SSRS report cell?

Thks!

Paul Miles Newbie Points: 1 More actions · Answer 4

Hi Lawrence, could try using a hyperlink from the report to a 'dummy' report passing the record key and data to update as parameters.

The 'dummy' report would then initiate its stored procedure which would update the database, and optionally re-call the original report to re-display the information, hopefully with the updated data. We did try this and it seemed to work, although the volume of data we wanted to persist led us down the route of developing a bespoke web application.

Hope I haven't missed the point of your question. Regards, Paul

Lawrence-136504 SSC Eights! Points: 961 More actions · Answer 5

Hi Paul,

Can you copy the code for exec Proc from dummy report. I'll have to the same thing you did.

Thanks,

L

philcart SSC-Forever Points: 47795 More actions · Answer 6

Lawrence, Grab hold of the DMVStats application from http://www.codeplex.com

The reports it uses do database inserts, etc...

I particularly like the report that allows you to enable/disable SQL Agent jobs 😀

--------------------
Colt 45 - the original point and click interface