RTC reports with children/parent information

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

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?

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,

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. 

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,

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,