I am on a project where i dont have access to the analysis services to customize the excel reports that TFS offers. I have also noticed that the TFS view - team explorer etc. CANNOT report on the test case status - failed, passed, blocked, not run etc.
and I cant query on them.
However, there is a excel report that TFS offers - Test Plan progress that displays the number of work items (test cases) that are in each status - failed etc.
Now i need to find out what the work item ID's are for the test cases that are in "not run" status? What is the best way to do that and is there a way to do that?
Any help is appreciated.
Thanks
Chandra.