This project is read-only.

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

Last edited Aug 2, 2012 at 6:04 AM by sstjean, version 5

Comments

akkireddy000 Jun 3, 2013 at 12:11 PM 
HI All,

Thanks for sharing the report,glad to see there is solution for test case reports.
Can you please send the RDL file used to upload here.
akkireddy000@gmail.com

Regards,
Akki

sstjean Aug 15, 2012 at 2:05 AM 
Glad that you could get the report installed correctly. :)

The Test Plan Status report will only show test suites that have test cases within them.

To determine what the report should show, open Microsoft Test Manager to your Test Plan. Select the "Test" activity. When the display changes look at the Test Suite tree view on the left side of the app. Those are the Test Suites that should be displayed in the report. A Test Suite that doesn't have any Test Cases will not appear. Is this what you are seeing? If not, please file a bug in the Issue Tracker above.

Thanks

AaronofKent Aug 15, 2012 at 12:06 AM 
I was able to get the reporting tool to see the Test Plans (and even changed the default value to my particular test plan), however, the report that is generated doesn't contain any Test Suites. Ideas?