Home > Articles > Data > SQL Server

  • Print
  • + Share This
This chapter is from the book

Report Manager

Report Manager is a web-based report access and management tool providing access to a single instance of a Report Server. Some of the operations that users can perform using the Report Manager include view, search and subscribe to reports, manage security (report access and roles), create folders and move reports around folders, manage data sources, set report parameters, and more. Actions that a user can perform using Report Manager depend on the user's security permissions. The default URL that invokes Report Manager is http://<server>/reports. The default directory that contains the Report Manager's binaries, pages, and so on is C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager.

Although Report Manager provides for a limited customization, it is neither designed nor supplied with sufficient documentation to support customization. This leaves companies with several customization options, which can be combined:

  • Accept limited customization capabilities of Report Manager, such as modification of style sheets it uses (by default located at C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles) and adjusting the name the Report Manager displays through the site settings (http://<server>/Reports/Pages/Settings.aspx).
  • Understand how Report Manager functions internally through the use of classes in the ReportingServicesWebUserInterface assembly and leverage its undocumented functionality.
  • Write custom management pages to replace one or more management pages in Report Manager (by default located at C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Pages).
  • Write a custom façade that would display a company's information and eventually take a user to the Report Manager pages.
  • Write a custom report management application to replace Report Manager.
  • + Share This
  • 🔖 Save To Your Account