Reporting from customized WI using Birt
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
On 9/17/2009 9:23 AM, bchrabski wrote:
Hello, 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
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 |
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, I believe the enumeration data set requires that you pass in PROJECT_AREA_ITEMID, are you doing this? james |
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) |
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 |
On 9/21/2009 4:08 AM, bchrabski wrote:
James, I believe the enumeration data set requires that you pass in PROJECT_AREA_ITEMID, are you doing this? james |
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 |
On 10/7/2009 2:37 AM, hanzas wrote:
Hi, 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
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.