CODEWITHSUNDEEP
sqlsql-serverdatabasereporting-services
Cătălin Rădoi
Cătălin Rădoi

Reputation: 1894

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?

Upvotes: 1

Views: 354

Answers (1)

Darren
Darren

Reputation: 70718

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.

Upvotes: 2

Related Questions