Post reply

MS Reporting Services 2005 - update underlying data source?

  • June 22, 2010 at 7:48 am

    #387195

    Hi

    Is it possible to create a simple reporting services (SSRS 2005) output of columns and rows and allow the end user to write back to the underlying data source table assuming they had the appropriate permissions?

    I want users to see data in a report and act on it by adding comments which get stored in an additional column along side the original data.

    Thanks

    LR

  • June 22, 2010 at 8:00 am

    #1183343

    The only real option built in to Reporting Services would be using a report parameter that is passed to a stored procedure that returns the report results as well as update the comments field you mention when supplied. This would be kind of cumbersome in my opinion. Reporting Services is just not intended to do anything other than display data.

    Another option would be to create some kind of web-based form (such as ASP, ASP.NET, ASP.NET MVC, ColdFusion, PHP, etc. pages) for updating the comments. You could set the Action property of a report element to point to the web form and pass in necessary variables as query string parameters when the link is clicked. If I were you, this would be the option I would choose.

    Good luck. 😉

  • June 22, 2010 at 8:04 am

    #1183348

    Thanks for getting back so quickly. I don't want to go down the web devp route just yet and I'm exploring other potential solutions.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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