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.
 Add a report server | 
|  Grant permissions to view or create reports |  Review team activities |
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.
Upload reports to your team project
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,
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 |
 |  |  |
 Note |
|---|
|
Open a Command Prompt in administrative mode and change to the directory where you installed the power tools.
 Copy Code | |
|---|---|
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.
| Copy Code | |
|---|---|
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.
Q and A
Q: How can I determine if my report is up to date?
A: To see when a report was last updated, check the Date Last Updated time stamp, which appears in the lower-right corner of each report.
Q: How often are reports refreshed?
A: Reports access data from the relational data warehouse (Tfs_Warehouse), which is updated every two minutes, and the cube (Tfs_Analysis), which is updated every two hours.
Q: How do I resolve issues causing reports to be out of date?
A: Reports will be out of date when all or some data stops flowing into the data warehouse. To verify the data flow, run the GetProcessStatus of the Warehouse Control Web service. Also, fix any schema conflicts that may be occurring.
Q: What tasks does tfpt addprojectreports perform?
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.
Q: What if I just want to upload a single report?
A: You can upload a single report using Upload file in Report Manager. You'll need to define the report's data source and possibly other parameters.
Q: What are the names of the data sources?
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.
Q: Can I upload reports from another process template?
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.
Q: What about uploading Excel 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.
Q: Can I get these same reports using Visual Studio Online?
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.
Try this next
Grant permissions to view or create reports.
Related content
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.
