It's all about the answers!

Ask a question

Reporting from customized WI using Birt


Bartosz Chrabski (3.4k12648) | asked Sep 17 '09, 9:19 a.m.
Hello,

Currently I am working over report form customized WI, but my main problem is getting value from my attributes like lists ( list of users ) and enumerations.

I have created data set on WORKITEMS_SNAPSHOT and Enumeration table but i get no results, it shows that table is empty.

Any ideas or help ?

Accepted answer


permanent link
James Moody (3.3k24) | answered Sep 17 '09, 1:41 p.m.
JAZZ DEVELOPER
On 9/17/2009 9:23 AM, bchrabski wrote:
Hello,

Currently I am working over report form customized WI, but my main
problem is getting value from my attributes like lists ( list of
users ) and enumerations.

I have created data set on WORKITEMS_SNAPSHOT and Enumeration table
but i get no results, it shows that table is empty.

Any ideas or help ?


For the Enumerations table, have you passed in as a parameter the name
of the enumeration? If you do this, it should return rows with all the
literals in the enumeration.

Just to check, are you running on a server with some meaningful data,
and have the data warehouse snapshots run? (If the server has been up
permamently for more than a day, then the snapshots should have run
automatically - if this is just a server you bring up occasionally, then
probably not).

Hope this helps.

james
RTC Reports Team Lead
Bartosz Chrabski selected this answer as the correct answer

7 other answers



permanent link
Bartosz Chrabski (3.4k12648) | answered Sep 21 '09, 3:59 a.m.
James,

Thanks for your reply, I have created data set on enumeration with no parameters so I should get all data. I've manually make snapshot using web UI so I do not this it is problem with refreshing.


Thanks for those movies but for me it does not work.

http://jazz.net/library/video/288
http://jazz.net/library/video/289

permanent link
Bartosz Chrabski (3.4k12648) | answered Sep 22 '09, 8:35 a.m.
Thanks for your reply, I've checked that even when I specify PROJECT_AREA_ITEMID the query returns no results.

On 9/21/2009 4:08 AM, bchrabski wrote:
James,

Thanks for your reply, I have created data set on enumeration with no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.


Thanks for those movies but for me it does not work.

http://jazz.net/library/video/288
http://jazz.net/library/video/289



I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?

james

permanent link
Rafik Jaouani (5.0k16) | answered Sep 17 '09, 9:48 p.m.
JAZZ DEVELOPER
You also need to pass in the project area. In 2.0.0.1, you can set the project area parameter to '{Current Project Area}' and that will give you the enumerations contributed by the project area you are reporting on.

For 2.0, it is a bit more complicated. The following two videos describe it:
http://jazz.net/library/video/288
http://jazz.net/library/video/289

Rafik Jaouani
Developer (Reports Team)

permanent link
Rafik Jaouani (5.0k16) | answered Sep 21 '09, 10:00 a.m.
JAZZ DEVELOPER
A data set with no parameters on the ENUMERATIONS table will always give you an empty result. As I have already stated, data sets based on the ENUMERATIONS table always require a project area to be passed.

You can go to this page and download the report design that is described in the video.

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

permanent link
James Moody (3.3k24) | answered Sep 21 '09, 10:02 a.m.
JAZZ DEVELOPER
On 9/21/2009 4:08 AM, bchrabski wrote:
James,

Thanks for your reply, I have created data set on enumeration with no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.


Thanks for those movies but for me it does not work.

http://jazz.net/library/video/288
http://jazz.net/library/video/289



I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?

james

permanent link
James Moody (3.3k24) | answered Sep 22 '09, 2:10 p.m.
JAZZ DEVELOPER
Interesting. Could you open a work item against the Reports component,
and attach your .rptdesign file (or a simplified one that demonstrates
the problem, if your report is sensitive)? That way we can debug the
problem more readily.

Thanks,

james
RTC Reports Team Lead

On 9/22/2009 8:38 AM, bchrabski wrote:
Thanks for your reply, I've checked that even when I specify
PROJECT_AREA_ITEMID the query returns no results.

jmoodywrote:
On 9/21/2009 4:08 AM, bchrabski wrote:
James,

Thanks for your reply, I have created data set on enumeration with
no
parameters so I should get all data. I've manually make snapshot
using web UI so I do not this it is problem with refreshing.


Thanks for those movies but for me it does not work.

http://jazz.net/library/video/288
http://jazz.net/library/video/289



I believe the enumeration data set requires that you pass in
PROJECT_AREA_ITEMID, are you doing this?

james


permanent link
James Moody (3.3k24) | answered Oct 07 '09, 1:21 p.m.
JAZZ DEVELOPER
On 10/7/2009 2:37 AM, hanzas wrote:
Hi,

I am trying to create the earned value chart using BIRT in RTC. This
Earned value chart should consist of Actual test execution series
against Planned test execution series for the selected iteration
(Test milestone).
When i tried to do this, am able to get the values for the Actual test
execution series for the selected iteration. when it comes for the
planned test execution series, planned startdate and planned end date
that i see on the RQM Testplan under test schedule data is not visible
in the datasets.
Please suggest me how to proceed? and if any similar report is already
existing request you to shed light on that too.
Any kind of help to get this Earned value chart are welcome.

Thanks,
Hanzas


Hi Hanzas,

I recommend that you post on the Rational Quality Manager forum, it
sounds like this is an RQM-specific question.

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.