Upload reports to a team project
By adding a report server to your TFS (on-premises) deployment, you can access a wealth of data about your team's projects, such as build quality, bug trends, burndown, and test progress. SQL Server Reporting Services (SSRS) reports provide insight to help teams manage work and improve processes.
After you've added a report server, you'll want to add reports to your team project. You can upload reports when connecting to an on-premises deployment of TFS 2010 or TFS 2012.
If the Reports page in Team Explorer appears empty, then you'll want to upload reports.
If the Reports page doesn't appear at all, then you'll want to add a report server.
Use the tfpt command line tool that TFS Power Tools provides.
Verify that you have the following tools, configurations, and permissions.
If you haven't installed TFS power tools, install them now.
If you haven’t installed Visual Studio or Team Explorer, install one of them now. You can download Team Explorer for free here. Team Explorer must be present on the same machine where you run the tfpt command line tool.
If you aren't an administrator for the team project, get added now.
If you haven't been added to the Content Manager or Team Foundation Content Manager role for SQL Server Reporting Services, get added now.
If you haven't installed the latest Quarterly Update for Microsoft Visual Studio Team Foundation Server 2012, install it now. This is the only way to obtain the latest version of the default process templates, which contains the latest version of the reports.
From Team Explorer, download the latest process template that is compatible with the one used to create your team project.
To determine the type of process template that was used to create your team project, review the work item types that appear in the New Work Item menu for Team Explorer and then compare them with the work item types in the following chart. If your work item types differ from those shown listed, then a custom process template might have been used.
Visual Studio Scrum
MSF for Agile
MSF for CMMI
In general, you can use the most recent version of the process template that was used to create your team project. For example, you can upload reports from Scrum 2.2 version, even if your team project was created with Scrum 2.0.
To download a process template, you need to be an administrator for the team project collection, and you must connect to TFS using the same version of Visual Studio or Team Explorer. For example, connect to TFS 2012 from Team Explorer 2012.
To learn more about process templates and work item types, go here.
Open a Command Prompt in administrative mode and change to the directory where you installed the power tools.
cd %programfiles%\Microsoft Team Foundation Server 2012 Power Tools
On a 64-bit edition of Windows, replace %programfiles% with %programfiles(x86)%.
Upload the reports. The process template you specify must be compatible with the one used to create the team project. And, it must have been uploaded to the team project collection that hosts your team project.
tfpt addprojectreports /collection:"http://MyServer:8080/tfs/DefaultCollection" /teamproject:MyProject /processtemplate:"TemplateName"
These are the names of the process templates uploaded with the latest quarterly update for TFS 2012 (later versions may be available):
Microsoft Visual Studio Scrum 2.2
MSF for Agile Software Development 6.2
MSF for CMMI Process Improvement 6.2
To overwrite reports that were previously uploaded, specify the /force option.
Open the report site from the Reports page in Team Explorer. You might need to refresh the page to see the newly uploaded reports.
And, here's a view of uploaded reports for a Scrum project in Report Manager.
Depending upon the amount of data that has been collected for your team project, it can take several minutes to several hours for the data warehouse and cube to build. Once they do, however, you can view progress for your team project since TFS was first deployed.
A: The tfpt addprojectreports command performs the instructions contained in the ReportTasks file of the process template. This file is located in the Reports folder of the process template. The tasks include creating report folders, setting report parameters and data sources for each report, and uploading reports to the report server.
A: The names of the reporting services data sources are Tfs2010ReportsDS and Tfs2010OlapReportsDS. Even though you may have installed or upgraded to TFS 2012, these names, which were assigned to the data sources for a TFS 2010 installation, are in use.
You can always check the names by opening the context menu for any report, choose Manage, and then choose Data Sources.
A: Most reports are customized based on the work item types and workflow states used in each process template. You might need to customize the reports you copy from another process template to fit the type definitions for your team project.
To learn about which reports are provided with which process templates, see Review team activities to support useful reports.
A: You can use tfpt addprojectportal command to add a project portal and Excel reports once you have added a SharePoint web application to your team project collection.
A: Not at this time. Uploading reports is only supported for TFS on-premises deployments.
For additional questions, go to the Microsoft forum: Team Foundation Server - Reporting & Warehouse.
Do you need to customize a report? Download SQL Server Report Builder 2012.
Do you need to learn more about how to create or customize TFS SSRS reports?
Do you want to learn more about the TFS cube? Perspectives and Measure Groups Provided in the Analysis Services Cube for Team System.