Post reply

ssrs 2008 using t-sql

  • November 17, 2016 at 4:16 pm

    #315917

    Can an SSRS 2008 report update a row in a sql server table?

    I am asking this question since I currently have a vb.net 2010 program that writes rows to a history table that is accessed by an ssrs 2008 report. If I could update the sql server table in the ssrs 2008 report, my project change would be a lot easier. The row in the sql server table that would be updated is defined as varchar(max).

    Thus can you tell if an ssrs 2008 report can update the varchar(max) column in a sql server 2008 table? If so, can you tell me how to accomplish this goal? If this is not possible, can you tell me another way to accomplish my goal using t-sql and not changing the vb.net application?

  • November 18, 2016 at 12:28 am

    #1913303

    Can't vouch for any of this, but here's a discussion very similar to what you're trying to do.

  • November 18, 2016 at 2:04 am

    #1913342

    Yes, you can add insert statements as a dataset then add the dataset

    I've used this technique to manually update user data via SSRS

    - Damian

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

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