View, organize, and configure reports using Report Manager
TFS 2018 | TFS 2017 | TFS 2015 | TFS 2013
After you create and publish reports in SQL Server Report Designer, you can use SQL Server Reporting Services' Report Manager to view, organize, and configure those reports. By using Report Manager, you can group related reports in folders, adjust parameters and data sources, and schedule automated reports. You can also configure different methods by which your reports are saved. For example, you can save a copy of a report (sometimes referred to as a snapshot) as report history. You can also export and save reports and have reports copied automatically to a file share.
When you open Report Manager, you start in the Contents page, which shows the items that you have permission to view. You might also have permission to add, delete, and move those items. For more information, see the following page on the Microsoft Web site: Contents Page (Report Manager).
After you click a report, you can perform one or more of the tasks that are described in this topic.
View a report
By using the View tab, you can display results for reports. You can adjust parameters, subscribe to the report, and navigate through the report. You can also refresh, export, and print the report. For more information, see the following page on the Microsoft Web site: Viewing Reports.
Configure report properties
By using the Properties tab, you can configure different aspects of a report. The Properties tab contains the following pages:
|Page||Task||Related topic on the Microsoft Web site|
|General||Modify Report Name, Description, or Definition.
On the General page, you can specify the name and a description of the report. You can also modify the report definition, either by editing a copy of the report or by uploading an .rdl file.
|General Properties Page, Reports (Report Manager)|
|Parameters||Modify Report Parameters.
On the Parameters page, you can view or modify the parameters that filter the data retrieved in your report. For example, you specify a date range to restrict the data that appears in the report. The Parameters page does not appear if no parameters were specified in the report definition before it was published.
|Parameters Properties Page (Report Manager)|
|Data Sources||Specify Data Sources.
On the Data Sources page, you can define how a report connects to an external data source. You can override the connection information that was specified when the report was published. By using this page, you can create a single report that can be run against different data sources.
|Data Sources Properties Page (Report Manager)|
|Processing Options||Configure Execution and Caching.
On the Processing Options page, you can control when and how often reports are processed. You can set reports to run during off-peak hours or you can cache reports to eliminate wait time if you have many users who access the same report.
|Processing Options Properties Page (Report Manager)|
|Snapshot Options||Configure Report History.
On the Snapshot Options page, you can configure whether and how many report snapshots are stored in report history.
|Snapshot Options Properties Page (Report Manager)|
|Security||Configure Report Security.
On the Security page, you can configure the security settings that determine access to folders, reports, models, resources, and shared data sources. This page is available only for items that you create or have permission to modify. You define access to items by assigning a group or a user to a specific role, which specifies the tasks that members of that role can perform.
|Security Properties Page, Items (Report Manager)|
View report history
By using the History tab, you can create, view, and delete report snapshots. Each snapshot contains the layout and data that are captured at a specific day and time. If you change the layout or if the data has changed, those changes will appear only in snapshots that were captured after the changes were made. Saved report snapshots are not affected. You can view history for a report only if you have access to that report, and you can view the history for only one report at a time. For more information, see the following page on the Microsoft Web site: Managing Report History.
View and modify subscriptions
By using the Subscriptions tab, you can create, view, and delete subscriptions for a specific report. A subscription is a standing request to deliver a report at a specific time or in response to an event. You can use subscriptions to schedule and automate delivery of the reports that you use often. For example, you could decide to have the results of your nightly build and test runs appear in e-mail to your team each morning.
You can create two types of subscriptions:
Standard subscription: A standard subscription consists of static values that cannot be varied during subscription processing. For each standard subscription, you can specify one set of presentation options, delivery options, and report parameters.
Data-driven subscription: Data-driven subscriptions retrieve their presentation options, delivery options, and report parameters from a data source at run time. You might use data-driven subscriptions if you want to vary report output for each recipient. For more information, see the following page on the Microsoft Web site: Data-Driven Subscriptions.
For each subscription, you can have reports automatically delivered to you by e-mail or copied to a file share. You configure the delivery details, schedule, and the parameter values. For more information, see the following page on the Microsoft Web site: Subscription Overview.