Search code examples
reporting-servicestfshierarchymdx

TFS - Generate a Report for Hierarchical Work Items

I have a hierarchical work items linked to gather as follows:

Parent-1
    Child-1
        sub-child-1
        sub-child-2
    Child-2
        sub-child-3
Parent-2
    Child-3
        sub-child-4

now based on the hierarchy above I need to create a report using SSRS to show the number of children and sub-children for each parent work item.

Solution

  • I've posted the same question in MSDN forums and they stated that I need to create SQL query to generate this kind of information and here is their answer