I am creating a report for my manager to help track what stage in the testing process her testers are in. We currently use VS 2012 for the development and MTM for test writing.

I tried creating a Query-based Test Suite in MTM that displays all tasks for certain testers/projects with no linked Test Cases. I can't figure out how to output these results. I can display all the tasks assigned to tester but can't marry the requirement of no test associated to backlog item.

This sounds somewhat straightforward. Can anyone help?

Thank you!


You can customize a report or export it to a Word or Excel File using TFS API.

  • Why would the TFS API work better for the OP? Customized reports that can be exported are available without the TFS API - you need to say what the API adds to make this a useful answer.
    – Kate Paulk
    Jul 27 '15 at 19:29
  • TFS API only should be used for MTM Test Suite Export, MTM does not support export to any Office Tools with customized Jul 28 '15 at 11:53
  • MTM test suites are viewable in the TFS web portal - which does support export to Office tools. Test cases can be queried like any work item. Using the API seems excessive to me when MTM can't operate without TFS and the information can be accessed through TFS.
    – Kate Paulk
    Jul 28 '15 at 12:27

The simplest method is to use the TFS Web Portal reports section and create a new report there using the SSRS report builder.

Alternatively, you can create a TFS query that gives you the information and connect to your TFS project with Excel, then link to that query.

Either way will get you that data you want.

  • Thank you! I have not seen the Reporting section and just took a gander. This may be just what I'm looking for.
    – Bug tester
    Jul 23 '15 at 16:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.