Creating a report based on TFS Query

Question

I need to create a hierarchical report , based on TFS query .

Each work Item returned by the query has two fields :

• Description – text  ( default system.description field )
• Level – a string filed , representing hierarchy level ( like 1.2 , 1.2.1 … )  ( my custom filed )

For example as a result of executing query I got the following results :

Level	Description
1	Bla Bla 1
1.1	Bla Bla 1.1
1.2	Bla Bla 1.2
1.2.1	Bla Bla 1.2.1

Now I need to create a report , which will display this data with indentation according to level .

1         Bla Bla 1

1.1         Bla Bla 1.1

1.2         Bla Bla 1.2

1.2.1      Bla Bla 1.2.1      

Preferable output format is WORD , but other options are also possible .

I don't have any knowledge in tfs reports , please give a guidelines of how achieve it .   

Answer 1

You can take a look at http://msdn.microsoft.com/en-us/library/ms244713.aspx to get information how to create a custom excel report.

---

Please remember to mark the replies as answers if they help.

Answer 2

Hi Leonod,

Thank you for your post.

How about the issue now?

Ewald has provided information in the reply, is there any help of this issue?

If anything is unclear, please free feel to let me know.

Best Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us