Using SSRS Built in Functions in SharePoint RRS feed

  • Question

  • Hi there,

    I currently have a number of reports deployed on a SharePoint site at work. I would like to monitor who actually uses which report and when they ran the report and also how long the report ran for. This is for auditing purposes and getting an idea of the performance of these reports.

    I came across the following built in functions on SSRS; UserID, ReportName, ReportServerUrl and ExecutionTime. Is it possible to use these functions somehow in SSRS & SharePoint whenever someone accesses a particular report and perhaps write this information to a SharePoint list within our SharePoint site.

    If this is possible, how would I go about doing this?

    Also, some of our reports run off parameters, is it possible to capture what parameters were used as well?

    Any help would be much appreciated. Thanks.  

    Tuesday, March 18, 2014 8:50 AM


All replies