TFS 2010 Work Item Tracking

re: TFS 2010 Work Item Tracking

Brian Harry MS — Mon, 21 Jan 2013 13:58:48 GMT

@MB, you can report on linked work items. Just create a report in Excel linked to the TFS warehouse, then add items from the "Work Item Linked" group. I just created a test report to prove to myself that it worked.

Brian

re: TFS 2010 Work Item Tracking

MB — Mon, 21 Jan 2013 06:17:26 GMT

I guess its not possible to create a excel report using linked work items query to see the data in excel.Any comments?

re: TFS 2010 Work Item Tracking

Aaron Bjork — Fri, 14 Dec 2012 16:34:17 GMT

@Bart - Thanks Bart... we did add support in TFS 2012 for inline images including cutting/pasting. You can give it a shot on the hosted service at http://tfs.visualstudio.com.

re: TFS 2010 Work Item Tracking

Bart Huls — Tue, 11 Dec 2012 16:07:33 GMT

Still missing a complete richedit workitem control to allow me to paste documents, images, etc... inline with the text.

Or are there any other solutions

re: TFS 2010 Work Item Tracking

Roger — Tue, 06 Dec 2011 02:42:06 GMT

Hi Brian,

I have a user request to keep the field FeatureOwner always same as System.AssignedTo, is there a way to accomplish this? I try this:

</WHENCHANGED>

Doing this the value copied was the value before the change took place, so it was getting the previous value instead of the currently newly set value.

I really like to use whennot to check if two fields are not the same, but there is no way to passing in another field for the whennot section.

Please help.

Thanks a lot

Roger

re: TFS 2010 Work Item Tracking

Brian Harry MS — Fri, 25 Nov 2011 10:04:46 GMT

it depends a great deal on what kind of solution you want. All of the TFS/VS apis are exposed so you can do almost anything. There are a number timesheet extensions already available both free and for pay. You might start by going to Codeplex.com and searching for "timesheet". At a minimum that will give you a bunch of samples for how other people have approached the problem.

Brian

re: TFS 2010 Work Item Tracking

Suresh Balaji — Thu, 24 Nov 2011 10:58:14 GMT

I want to make addin to manage each work item using time sheet how is it possible ?

re: TFS 2010 Work Item Tracking

Brian Harry MS — Thu, 17 Feb 2011 14:33:16 GMT

yes, if you have Team Explorer installed on the client, it adds an Excel add-in that allows you to create a bound list to TFS. Look at the Team ribbon and click "New List".

Brian

re: TFS 2010 Work Item Tracking

Rajendra — Mon, 14 Feb 2011 18:33:44 GMT

Hi Brian,

Your blog is informative. Is there a way to maintain a connection with TFS database when I export work item hierarchy query to excel. This way, I do not have to export the query results everytime, I want to run a report.

Thanks in advance,

Rajendra

re: TFS 2010 Work Item Tracking

Matthias Künzi — Thu, 03 Feb 2011 07:56:23 GMT

Hi, Can you give me an example of a workitem report showing all workitems of a specific type and all related workitems. I need such a report to get out e.g. all requirements and subrequirements of a project. I have the idea to to this with the Report Designer to get a nice formatted and printable report. Can you give me any help about this. Thanks. Matthias.