How can tfs work item details be exported?

Question

I don't seem to be able to export tfs work items along with their details, is there any way to do this without using TFSIntegrationTools? (I cannot install these at my work).

Specifically I want to be able to export the Description portion of the Work Item details:

e

Answer 1

If all you need is the work item data then I would design a flat query, run it and then open it up in Excel. You can modify which columns are visible. Once open you can save it off or print or form a report in excel or what have you.

Your other options are to query the warehouse in sql server or query in code.

http://blogs.msdn.com/b/sunder/archive/2010/03/02/reporting-in-team-foundation-server-part-7-excel-reports-from-work-item-queries.aspx

Answer 2

I had the same problem, but I could not benifit from excel, because I wanted to send the list to someone who doesn't have access to the local TFS. So I created a tool to help with that.

In case this helps any one, here is the link to download release one excutables from codeplex https://tfsworkitemsexporter.codeplex.com/

please also feel free to copy the code and edit as you like