Hi,
I don't have a lot to say about this, except that I think this idea is brilliant in its simplicity. I've been using Reporting Services for about 2 years now, and I would never have thought of this (maybe I'm just dumb??). As a DW developer, I'm often asked for seemingly simple things like - "how can our admin user trigger a month-end process to start once we're happy with the source data". I give them various options, all of which are usually pretty poor, eg how about 'right-click, start job' in enterprise manager? I guess this is because I have virtually no App Dev skills, and can't just put together a nice little webpage or desktop app. I suppose I can now have a report with a list of admin tasks (sql agent jobs) which are all hyperlinks which will go away and sp_StartJob the job when clicked. Handy!
Matt.
Wonderful! In meeting just yesterday expressing the same type requirements for a DR tracking application. I also have been using RS and now SSRS since it came out. We are very interested in editing via a report because there is so much functionality built in RS that our developers sometimes have difficulty providing via the web app.
Could you provide and example of the hyperlink code/expression that calls the sproc again and the sproc itself? Can't quite get my brain around it. But then it's awful early!
AB
Reporting = R
Applications = CRUD
I have to agree that Reporting should be reads. Applications should be CRUD. But then you have the argument, Reporting Services is an Application. =)
This could work with limited exposure (such as working through a checklist) but could also be dangerous if someone tries to make this thier data management tool.
Good Article, Clever solution.
For anything more than just marking a field status or flipping a bit on or off, I would recommend using the .NET 2.0 and ASP.NET 2.0. They have made some nice improvements for data interaction.
Im going to go against the grain and say that I don't really care for the solution (though I appreciate what you were trying to accomplish). In general I dont think reports should modify base data. One alternative thats easy enough to manage without code would be linking the table into an Access mdb.
Is there anyway you could share the reporting solution source files with teh rest of us who are curious as to how you did this? The article is great in showing that this can be done with RS but lacking in how it's done and a good article shoudl do both
