Proka Proka - 6 months ago 4
SQL Question

Update SQL Database from Report (SSRS / Catch Export Event)

In an RDL file, if the user exports to PDF (let's say), I want to mark some rows from the report, in the MSSQL database, as being exported. Can I do that from the RDL itself?


The RDL is purely used for presenting the data. You cannot attach to the Export to PDF button in SSRS and then UPDATE the database.

An alternative would be to use an ASP.NET web page with the Report Viewer control with a custom button that exports to PDF and then calls some server side code to UPDATE the database with the marked rows.