Report Manager (SSRS)

Article
04/01/2012

Report Manager is a Web-based report access and management tool that you use to administer a single report server instance from a remote location over an HTTP connection. You can also use Report Manager for its report viewer and navigation features. You can use Report Manager to perform the following tasks:

View, search, print, and subscribe to reports.
Create, secure, and maintain the folder hierarchy to organize items on the server.
Configure role-based security that determines access to items and operations.
Configure report execution properties, report history, and report parameters.
Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source.
Set model item security to allow access to specific entities in the model, or map entities to predefined clickthrough reports that you create in advance.
Create shared schedules and shared data sources to make schedules and data source connections more manageable.
Create data-driven subscriptions that roll out reports to a large recipient list.
Create linked reports to reuse and repurpose an existing report in different ways.
Launch Report Builder to create reports that you can save and run on the report server.

You can use Report Manager to browse the report server folders or search for specific reports. You can view a report, its general properties, and past copies of the report that are captured in report history. Depending on your permissions, you might also be able to subscribe to reports for delivery to an e-mail inbox or a shared folder on the file system.

Note

For information on supported browsers and versions, see Planning for Reporting Services Browser Support.

Report Manager is used only for a report server that runs in native mode. It is not supported for a report server that you configure for SharePoint integrated mode.

Some Report Manager features are only available in specified editions of SQL Server. For more information, see Features Supported by the Editions of SQL Server 2012.

On a new installation, only local administrators have sufficient permissions to work with content and settings. To grant permissions to other users, a local administrator must create role assignments that provide access to the report server. The application pages and tasks that a user can subsequently access will depend on the role assignments for that user. For more information, see Grant User Access to a Report Server (Report Manager).

Note

If you are using Windows Vista or Windows Server 2008, you must configure Report Manager for local administration. For more information, see Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008.

Starting and Using Report Manager

Report Manager is a Web application that you open by typing the Report Manager URL in the address bar of a browser window. When you start Report Manager, the pages, links, and options that you see will vary based on the permissions you have on the report server. To perform a task, you must be assigned to a role that includes the task. A user who is assigned to a role that has full permissions has access to the complete set of application menus and pages available for managing a report server. A user assigned to a role that has permissions to view and run reports sees only the menus and pages that support those activities. Each user can have different role assignments for different report servers, or even for the various reports and folders that are stored on a single report server.

For more information about roles, see Granting Permissions on a Native Mode Report Server.

Note

If you are using Windows Vista or Windows Server 2008, you must configure the report server for local administration before you can use Report Manager to manage a local report server instance. For instructions on how to configure the server, see Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008.

Starting Report Manager

To start Report Manager from a browser

Open Microsoft Internet Explorer 6.0 or later.
In the address bar of the Web browser, type the Report Manager URL. By default, the URL is http://<ComputerName>/reports. The report server might be configured to use a specific port. For example, http:// <ComputerName>:80/reports or http:// <ComputerName>:8080/reports.

Configuring Report Manager

Report Manager configuration consists of defining a URL for the application. Additional configuration is required if your deployment includes running Report Manager on a separate computer.

You can customize Report Manager in very limited ways. For example, you can modify the application title on the Site Settings page. If you are a Web developer, you can modify the style sheets that contain the style information used by Report Manager. Because Report Manager is not specifically designed to support customization, you must thoroughly test any modification that you make. If you find that Report Manager does not meet your needs, you can develop a custom report viewer or configure SharePoint Web parts to find and view reports in a SharePoint site. For more information, see Configure Report Manager.

Icon Descriptions

The following table describes the icons that are used in Report Manager. For more information about the icons that appear in the report toolbar, see HTML Viewer and the Report Toolbar.

Icon	Description	Action
	Report	Click the report icon or name to open the report. The report opens in a separate window.
	Report model	Click the report model icon to open model property pages.
	Linked report	Click the report icon or name to open the linked report. The report opens in a separate window.
	Folder	Click the folder icon or name to open the folder.
	Subscription	Click a subscription icon or description to edit a subscription.
	Data-driven subscription	Click a data-driven subscription icon or description to edit a subscription.
	Resource	Click the resource icon or name to open the resource. The resource opens in a separate window.
	Shared data source item	Click a shared data source icon to open the property pages, report list, and subscription list of the data source.
	Property page	Click the property icon to access additional pages to set properties and security.