To install the report into your TFS SQL Server Reporting Services instance you have to perform the following steps:

1.  Unzip the downloaded release zip file into a folder.

2.  Open a browser and navigate to:   http://<yourTFSserver>/reports (Be sure to replace <yourTFSserver> with the name of the server that houses your Reporting Services instance)

3.  In the main Report Manager screen click on the TfsReports link.

SNAGHTML8b37127

 

4.  Click on your Team Project Collection name.  The default TPC name is DefaultCollection.

SNAGHTML8b5d90d

 

5.  Click on your Team Project’s name.  In the example below, the Team Project is named Tailspin Toys.

SNAGHTML8b7c242

 

6.  Click on the folder that you will contain the report you are installing.  In this example, I am installing the Test Plan Status report so the appropriate folder is Test.

SNAGHTML8ba4cb6

 

7. Once you are in the folder that will house the report, click on the Upload File button.

SNAGHTML8bc0bc0

 

8. In the Upload File page click on the Browse button and navigate to the location where the report’s RDL file was extracted.  Double-click on the report RDL file to make the selection. Click the Ok button to upload the report definition file.

SNAGHTML8c0cea1

 

9. Back in the report’s folder you should see the uploaded report marked with !New. Click on the report name hyperlink to launch the report.

SNAGHTML8c2fc27

 

10.  You will probably receive an error when you run it for the first time.  The error will read:

“The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)”

This means that the data source connection information that we used to create the report doesn’t match the name of the connection in your Reporting Services instance.  To reset the connection you can click on the Properties tab.

SNAGHTML8c51be6

 

11.  In the Test Plan Properties page, click on the Data Sources tab.

SNAGHTML8c859e0

 

12.  In the Data Sources tab you can see that the report is looking for a data source named TfsReportDS  Team Foundation Server 2010’s SSRS instance doesn’t have a data source with this name.  It’s name is Tfs2010ReportDS so you will have to wire that data source to the report.

Start by clicking on the Browse button.  This will open up the Browse for data source page. Select the Tfs2010ReportDS data source then click the Ok button. Back in the Data Sources tab you now have to click the Apply button to save the change. 

NOTE: You may have to scroll down the Data Sources tab to see the Apply button.  If you forget to click the Apply button the data source will not be set and the report will continue to fail to run.

Click on the View tab to reload the report.

SNAGHTML8d5f841

 

13.   If everything worked, you should see the report render (if it has default settings) or at least you will see the report parameters. In the example below, the Test Plan Status report has a Test Plan Name parameter that has to be selected by the user.  We select the Project Antares test plan and click the View Report button to run the report.

SNAGHTML8d9afcc

 

14. The result should be a report that holds data like the example below.

SNAGHTML8dae8c6