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?