Microsoft SQL Server 2005 Reporting Services, 2nd Edition

10.6. Managing Reports on the Report Server

Now that you have moved some of your reports to the Report Server, you may be thinking your job is about done, but it is just beginning. Now you need to manage the reports and supporting materials to ensure the reports can be utilized properly by your users.

Two of the biggest concerns when it comes to managing reports are security and performance. Reports containing sensitive data must be secured, so they are only accessed by the appropriate people. Reports must return information to users in a reasonable amount of time without putting undo stress on database resources. Fortunately, Reporting Services provides tools for managing both of these concerns. Security roles and item-level security give you ...