It's all about the answers!

Ask a question

Report Builder - Parent / Child connection troubleshooting.

Sterling Ferguson-II (1.6k8280269) | asked Oct 09 '23, 11:21 a.m.


I want to display any Story where the child Task = Closed to see the status of that Story and ALL child Tasks. 
  1. Story with 3 Tasks all In Progress = nothing shown.
  2. Story with 3 Tasks with 2 In Progress, one is Closed = Display Story, Status, Child, Status (of all 3).
Trace Relationships
Parent (required)/All Link Types Child

Parent - Type = Story
Children - Status = Closed

Report shows Stories with Children Status = Closed (Yay) However, it ONLY displays the Tasks = Closed, not the other Tasks that are In Progress or New.  How do I correct the Conditions that get example #2 above to display? I'm sure it involves something maybe nestled?

Accepted answer

permanent link
Fariz Saracevic (904613) | answered Oct 11 '23, 5:05 p.m.

Hi Sterling,

Not sure if you already found a solution but trick is in the trace relationship. Here is what I have selected and then condition for the closed children work items.
In your environment, work items types might be different. Therefore, here is public report link and this should provide you details your are looking for


Sterling Ferguson-II selected this answer as the correct answer

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.