Poblem with BIRT Report for RTC

The trick is to apply filters on both of the data sets, which is not feasible with the LINKS table. You could try the LIVE_SNAPSHOT table com.ibm.team.links.AuditableLink, which at least allows you to filter on type but that won't be enough if the repository is large. Or you could try the LIVE_SNAPSHOT table com.ibm.team.linkClosure.Relation, which extracts ancestors/descendants rather than parents/children but lets you filter on project area, type and more.The alternative is to script it

I assume you have tried target.itemId in WI_ITEMID. If that doesn't work, have you tried creating a simple data set?

Both does not work. Background of the problem is:

Must list all Storys of a team, with sum of all children estimates.
Example:

Story 001 | Summary
_____________________ Task 002 | Summary | Estimate
_____________________ Task 003 | Summary | Estimate
___________________________________ΣTaskstimate    

Story 004 | Summary
_____________________ Task 005 | Summary | Estimate
_____________________ Task 006 | Summary | Estimate
___________________________________ΣTaskstimate                                                          

Option 1:
Retrieving linked items with nested tables. Do not work because each child was in a separate table and therefore it was not possible to make the sum of estimates.

Option 2:
Do Children Dataset Join (Parent Dataset Join Links Dataset).Do not work because jazz query result set is limited