How to make SSRS reports available to users?

  • I've been thinking of the best way to present reports to the end user. We're accumulated several dozen reports.

    There's the option of sending the users the direct link to the reports. We don't do this because it's not easy to find (they have to dig through emails or bookmark the link)

    http://server/ReportServer/Pages/ReportViewer.aspx?myreportrs:Command=Render

    We've been embedding reports in sharepoint (or simply adding a link to the report). We're not using Sharepoint Integrated Mode. This has become a little unorganized where we have a large number of links to reports. How do you have your reports organized so that the end user can find them and use them easily.

    SQL 2008, Sharepoint 2008

  • Hi

    did you try the builtin SSRS GUI under http://yourservername/reports? You can easily manage your reports there, organize them in folders and set permissions to view items on folders by linking AD-groups. Another way I once used is to access the reporterver metadata in the db and build individual lists of links to reports in asp.net. There is a log of every report execution (you can configure the time the data is stored), so I built a website that showed every user his last 10 executed reports and his most frequently accessed reports.

    Lars

  • Have you trie the subscription part.

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

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