SQL Server Reports

  • Is it possible to create a sql server report in Microsoft Visual Studio 2003 or 2005 or 2008 which can be used to update a sql server database 2008?

    Can a report be used at all to update database values?

  • Yes if the query it calls is an update / insert / delete proc.

    If you want to make it user controlled via a report object then you will need to look at writing an external assembly and embedding it into the report.

  • "If you want to make it user controlled via a report object then you will need to look at writing an external assembly and embedding it into the report."

    Would it be possible to provide me an example for the above process.

  • Google will be your friend on that one, I have not yet had the need to make a report update a databases, but know it can be done via external assemblies.

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

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