It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787

question asked: Jun 04 '09, 2:30 p.m.
question was seen: 5,286 times
last updated: Jun 04 '09, 2:30 p.m.

Related questions

FAQ - How this Forum works

Want to generate a report of story and its childrens

0
Santhosh Thenmozhi Rajendran (71●19●10) | asked Jun 04 '09, 2:30 p.m.
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

3 answers

Most liked answers|Newest answers ↑|Oldest answers

0
permanent link
Rafik Jaouani (5.0k●1●6) | answered Jun 09 '09, 5:55 p.m.
JAZZ DEVELOPER
Sany, unfortunatly, you won't be able to do that in 1.0.1.1.

This was a feature we were asked to implement in 2.0.
0
permanent link
Santhosh Thenmozhi Rajendran (71●19●10) | answered Jun 09 '09, 5:15 p.m.
Hi James,

I am using RTC 1.0.1.1, Is there anything available in this version?

Thanks,
Sany
Praise Parents
0
permanent link
James Moody (3.3k●2●4) | answered Jun 05 '09, 10:44 a.m.
JAZZ DEVELOPER
On 6/4/2009 2:37 PM, trsanthosh wrote:
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

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.