It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×42,854

question asked: May 19 '10, 7:55 a.m.
question was seen: 6,112 times
last updated: May 19 '10, 7:55 a.m.

Related questions

RTC reports with children/parent information

0
Milan Krivic (980●13●176●143) | asked May 19 '10, 7:55 a.m.
Hi,

Is it possible to create report with work items which have, for example, same parent, or any work item which have just parent and reverse? I 've been looking into DataWarehouseSnapshotSchemas chapter, and haven't found that attribute in tables.

Thanks,

Milan

6 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
James Moody (3.3k●2●4) | answered May 20 '10, 9:32 a.m.
JAZZ DEVELOPER
On 5/19/2010 8:08 AM, milan.krivic wrote:
Hi,

Is it possible to create report with work items which have, for
example, same parent, or any work item which have just parent and
reverse? I 've been looking into
DataWarehouseSnapshotSchemas chapter,
and haven't found that attribute in tables.

Thanks,

Milan


Hi Milan,

I think we connected elsewhere, but for anyone else wondering, the
parent/child relationship is stored in the links table. There are two
interesting reports in Reports Central that might help:

https://jazz.net/wiki/bin/view/Main/ReportsCentral

Look at the Links example (which includes a video), and the Work
Progress example. Both have downloadable .rptdesign files that should help.

james
RTC Reports Team Lead
0
permanent link
David Murphy (11●1●4●3) | answered Feb 07 '12, 2:03 p.m.
I went to retrieve the Work Progress.rptdesign file and download it but what I get is the Work Progress.xml. I am not sure how to proceed from here. I wanted the .rptdesign file. Is there some translation process I am missing here?
0
permanent link
Milan Krivic (980●13●176●143) | answered Feb 07 '12, 3:52 p.m.
I went to retrieve the Work Progress.rptdesign file and download it but what I get is the Work Progress.xml. I am not sure how to proceed from here. I wanted the .rptdesign file. Is there some translation process I am missing here?


You can right click and tell "Save Link As" or "Save Target As"....
Then, optional, you can choose All Types of document and click save...

And you must have appropriate eclipse plugins depending which type of RTC client you are using.

Regards,
0
permanent link
Scott Crouch (485●3●24●26) | answered Mar 14 '12, 11:50 a.m.
While trying to learn how to create a report in BIRT that shows a relationship between parent/children I ran across the Work Progress example and I'm pretty sure this is 95% of what I was trying to do on my own :).

The only problem is that when I run the report I get the below error. I'm going to try and troubleshoot the error, but I'm hoping y'all have seen it before and can point me in the right direciton.

The following items have errors: 


Table (id = 34): 

- An exception occurred during processing. Please see the following message for details:

Failed to prepare the query execution for the data set: Children

Cannot convert the parameter value 179,769,313,486,231,570,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 to type class java.lang.Integer.

Can not convert the value of 1.7976931348623157E308 to Integer type.
0
permanent link
Milan Krivic (980●13●176●143) | answered Mar 14 '12, 12:00 p.m.
While trying to learn how to create a report in BIRT that shows a relationship between parent/children I ran across the Work Progress example and I'm pretty sure this is 95% of what I was trying to do on my own :).

The only problem is that when I run the report I get the below error. I'm going to try and troubleshoot the error, but I'm hoping y'all have seen it before and can point me in the right direciton.

The following items have errors: 


Table (id = 34): 

- An exception occurred during processing. Please see the following message for details:

Failed to prepare the query execution for the data set: Children

Cannot convert the parameter value 179,769,313,486,231,570,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 to type class java.lang.Integer.

Can not convert the value of 1.7976931348623157E308 to Integer type.


Hi Scott,

locate Children dataset, double-click to edit it, go to Parameters and change the RESULT_SET_SIZE expression you have in it to this:

if (done) {
0;
} else {
java.lang.Integer.MAX_VALUE;
}

Hope this helps,
0
permanent link
Scott Crouch (485●3●24●26) | answered Mar 14 '12, 1:32 p.m.
This fixed that issue. Thank you very much for your quick response.


While trying to learn how to create a report in BIRT that shows a relationship between parent/children I ran across the Work Progress example and I'm pretty sure this is 95% of what I was trying to do on my own :).

The only problem is that when I run the report I get the below error. I'm going to try and troubleshoot the error, but I'm hoping y'all have seen it before and can point me in the right direciton.

The following items have errors: 


Table (id = 34): 

- An exception occurred during processing. Please see the following message for details:

Failed to prepare the query execution for the data set: Children

Cannot convert the parameter value 179,769,313,486,231,570,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000 to type class java.lang.Integer.

Can not convert the value of 1.7976931348623157E308 to Integer type.


Hi Scott,

locate Children dataset, double-click to edit it, go to Parameters and change the RESULT_SET_SIZE expression you have in it to this:

if (done) {
0;
} else {
java.lang.Integer.MAX_VALUE;
}

Hope this helps,

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.