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, TFS 2012, or TFS 2013.
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, 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. 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 Microsoft Visual Studio Team Foundation Server 2013, 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 Microsoft Visual Studio Scrum 2013 version, even if your team project was created with Microsoft Visual Studio 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 2013 from Team Explorer 2013.
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 2013 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 TFS 2013:
Microsoft Visual Studio Scrum 2013
MSF for Agile Software Development 2013
MSF for CMMI Process Improvement 2013
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.
Try this next
Q & 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. You can, however, chart the results of a flat-list query.
How do I customize a report?
A: You can customize the reports you uploaded using SQL Server Report Builder 2012. To learn more, see Creating Reports for Team Foundation Server 2010 and Customizing Reports for Team Foundation Server 2010. Even though these articles are based on TFS 2010, they are valid for TFS 2013.
How can I learn more about the TFS cube?
Where can I go if I have more questions?
A: Search for an answer or post a question in the Team Foundation Server - Reporting & Warehouse forum.