Want to generate a report of story and 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
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
3 answers
On 6/4/2009 2:37 PM, trsanthosh wrote:
Hi Sany,
Are you using a 2.0 beta, milestone, or release candidate? If so, check
out our example report called "Story Child Work Items.rptdesign". It's
in the "live" folder of com.ibm.team.examples.reports.common. It does
almost exactly what you're looking for. I assume you're looking for live
(up-to-date) data rather than historical data from the warehouse.
james
RTC Reports Team Lead
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
Hi Sany,
Are you using a 2.0 beta, milestone, or release candidate? If so, check
out our example report called "Story Child Work Items.rptdesign". It's
in the "live" folder of com.ibm.team.examples.reports.common. It does
almost exactly what you're looking for. I assume you're looking for live
(up-to-date) data rather than historical data from the warehouse.
james
RTC Reports Team Lead