Want to generate a report linking story with its childrens

Hi,

I am using BIRT to generate custom reports, I have a task to generate a report with following fields,
ID, Story summary, childrens of that story.

I can generate a query which gives me the result, but I couldn't find a snapshot which has the details to generate it in a report. I tried in "WorkItem_snapshot" and browsed through all the tables but couldn't find the column which contains the children data.

Any help will be appreciated.

Is there any out-of-box way to convert a jazz query to a report?



Thanks,
Sany