It's all about the answers!

Ask a question

How to create a RTC Parent and related open Children task Report / Epic and open Story report


Thomas E (1312) | asked Apr 21 '17, 7:47 p.m.

Using CMS NG.  We need to create a report that will be run regularly, we have been provided a list of 15 specific Epics and need to create a report for these 15 Epics that display all of their related open Children (Story).  This will be need to be exported into Excel.

From the Epic we need this field:

  • Epic #
  • Summary

From the Stories, we need following fields:

  • Story #
  • Filed Against
  • Category
  • Creation Date
  • Created By
  • Due Date
  • Description

Any help here would be greatly appreciated – this will be run and trended daily.   To not have to pull this out of the GUI will be a huge time save for this team.

Thank you

Accepted answer


permanent link
Ralph Schoon (63.1k33645) | answered Apr 22 '17, 2:13 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
edited Apr 22 '17, 2:18 p.m.

What is CMS NG and why would Jazz forum users know what it is?

Assuming that the question is related to RTC, as the summary suggests, look at the Report Service that is available since RTC 5.0.2. There is no version number in the question, so it is impossible to tell if you have this available or not, which actually makes it a bit pointless to try to answer. The Report Service is the best option in any case.

Use tags or other means to identify the Epics.

Other options would be

1. Work item queries, again using tags.
2. Plans (if all the work items are planned for the same iteration and filter by tag.

https://jazz.net/library/article/1493
https://jazz.net/library/article/1490
https://jazz.net/library/article/1470

Thomas E 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.