Post reply

SSRS- Action SQL Script

  • April 6, 2016 at 3:38 am

    #326254

    Hi,

    I have a landing page in SSRS that consists of icons (images) that you click to take you either to other SSRS reports / mailto: / shared folder. I need a way of auditing who is clicking what.

    I can get the time / date and user easily, I was just wondering if there is a way to execute an insert SQL command when one of the images is clicked?

    In terms of images that link to other SSRS reports I can audit by ReportServer execution logs I just need a way of auditing the mailto: and shared folder links.

    Thanks in advance.

    Paul

  • April 8, 2016 at 5:39 am

    #1870755

    I have been able to manage this with a workaround.

    Basically the user clicks the icon that actions a go to URL. This then launches an aspx webpage that inserts a record into the audit table then from there either opens a network drive or forwards onto another SSRS report.

    Thanks,

    Paul

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

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