Share via

View, upload, and organize Reporting Services reports

  • Article

TFS 2017 | TFS 2015 | TFS 2013

You can analyze the progress and quality of your project by viewing the reports in SQL Server Reporting Services.

Note

This article applies to TFS-2017 and earlier versions. Starting with TFS-2018, the integration of SQL Reporting Services and Team Explorer was deprecated.

The ReportReports page in Team Explorer provides a tree view of the reports defined for your team project. To open a report, choose it and press Enter.

Note

The Report Reports option appears only when the team project collection that contains your team project is provisioned with Reporting Services. For more information, see Add a Report Server to a Team Project Collection.

The ReportReports page for your team project shows the reports and organizes them under a set of folders. The default set of reports is based on the process template that was used to create the team project. You can manage these reports using Report Manager. For more information, see Report Server Content (Native Mode).

The reports that TFS provides with the default process templates provide a view of the current state of your project. They do so by aggregating and summarizing the metrics from:

  • Work items.
  • Version control.
  • Test results.
  • Builds.

You can use the default reports, or you can customize each report to fit your specific needs.

Most of these reports provide filters that you can use to specify contents to include in the report. Filters include time period, iteration and area paths, work item types, and work item states. The questions that they answer relate to all types of work items such as user stories, test cases, tasks, and bugs. For more information about the purpose, layout, or use of each report, see Reporting Services Reports.

Team project reports are stored in Reporting Services, and you can access them through Team Explorer or Report Manager. As the number of reports listed on the Reports page increases, you may want to create subfolders for grouping or organizing the reports.

You use Report Manager to manage reports and report folders. To access the team report site from Team Web Access, on the Home page, select Report Reports.

Prerequisites

  • To open a report from Team Explorer, your View project-level information permission on the team project must be set to Allow. You must also be a member of the SQL Server Reporting Services Browser role.

  • To manage reports from Report Manager, you must be a member of the SQL Server Reporting Services Team Foundation Content Manager role. For more information, see Grant permissions to view or create reports in TFS.

    Note

    If you are running Windows Server 2008 or Windows Vista, you might have trouble opening Web pages or sites from Team Explorer. For example, you might not be able to open the project portal by right-clicking a team project in Team Explorer and then clicking Show Project Portal. For more information about access issues that may occur with Windows Server 2008 or Windows Vista, see the following page on the Microsoft Web site: User Account Control.

View a report from Team Explorer

  1. From the Home icon home page in Team Explorer, choose ReportReports.

    Note

    If a red X icon appears next to ReportReports, you might not have permissions to access the reports, or Team Explorer might have lost communication with the server that hosts Reporting Services. In these instances, check with your project administrator to make sure that you have permissions to access the reports and that the server that hosts Reporting Services is running.

    Also, a red X icon might appear next to Reports if both of the following conditions are true:

    • Team Explorer is running on the same computer as Reporting Services.

    • You aren't signed in as an administrator, or enhanced security is enabled for Internet Explorer.

    To correct this issue, sign in to your computer as an administrator, or open Internet Explorer, open Internet Options, choose the Security tab, and clear the Enabled Protected Mode check box.

  2. Choose the report and then press Enter.

    A web browser window opens and shows the report.

  3. At the top of the report, specify your filter parameters, and then choose View Report.

View a report from Report Manager

  1. From the Home icon home page in Team Explorer, choose ReportReports, and then choose the Go to site link.

    Or, choose Team, Show Report Site from the Visual Studio toolbar.

  2. In Report Manager, choose the folder that contains the report you want to view.

  3. Choose the report that you want to open.

  4. At the top of the report, specify your filter parameters, and then choose View Report.