Proka Proka - 2 years ago 75
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?

Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download