From Microsoft Test Manager, it is possible to identify the state of test cases (pass, fail, blocked etc) for a particular test suite. You can just select the test suite on the left side and the right pane would show all test cases with their test status.
Figure 1 – Selecting a test suite shows the state of all test cases in that test suite
However, getting the same information at a test plan level is not easy. In the Test Plan properties view, you can see a pie chart indicating the state of all test cases in a given test plan.
Figure 2 – Pie chart in test plan properties indicating overall state of all test cases in the test plan
But, it is not possible to drill down deeper to identify which if the test cases are failing in the test plan.
The workaround – Creating your own Excel Reports
Figure 3 – Excel report showing state of all test cases (grouped by configurations) in a test plan
Figure 4 – You can drill down to identify failing test cases in a particular test plan
Steps to create this Excel Report
Figure 5 – The PivotTable used to create the Excel Report
Once you’ve created a PivotTable report (steps 1 to 6 given here), you can create a report with the following fields:
1. Team Project. [Team Project Hierarchy] – Select the team project for the report
2. Test Suite.[Test Suite Hierarchy] – Drill down to select the test plan for the report.
1. Test Configuration.[Configuration Name] – Test Configurations selected under the report filters.
2. Test Case.[System_Title] – The names of all test cases, grouped by test configuration
1. Test Result.[Outcome] – the state of the test case (failed, passed, never run, error, blocked or aborted)
1. Test. [Point Count Tread] – indicates the count of all test points (test cases x configurations) satisfying the row/ column labels