It's all about the answers!

Ask a question

BIRT create report - List workitems included in more than one project


Omar Mezarina (111) | asked Nov 29 '12, 3:19 p.m.
Hi Folks,

I want to create a report that include a list of all workitems (with their time spent) included in more than one project area. For example, I have a project area named "Project1" with three workitems named "WI1", "WI2", "WI3", and another project area  named "Project2" with two workitems named "WI4", "WI5", "WI6". Is it possible to create a report like this:

Project1
       WI1    8
       WI2    4
       WI3    8
Project2
       WI4    4
       WI5    4
       WI6    4

Thanks a lot in advance.

2 answers



permanent link
Vladimir Amelin (70472226) | answered Nov 30 '12, 2:13 a.m.
edited Nov 30 '12, 2:14 a.m.

You should create BIRT or RRDI report to make such cross-project list. Built-in queries are restricted to current project area.

However there are couple of tricks:

1) Use reportable REST API to get xml and work with it in spreadsheet app. Like this:

https://server:9443/ccm/rpt/repository/workitem?fields=workitem/workItem[projectArea/name='Project1' or projectArea/name='Project2']/(id|summary|state/name|projectArea/name)&size=100000

2) Use unsupported way:

http://mikemacd.wordpress.com/2011/10/10/rtc-how-to-write-cross-project-queries/


permanent link
Tal Rabinovitch (4721615) | answered Dec 02 '12, 2:47 a.m.
 Hi, 
Should be fairly easy to do.
What you basically need to do is create two different 'Data Sources'. each one will extract its data from a different project area.
Once you have these two defined, you can create whatever 'Data Sets' you want in order to extract the data you need from each Data Source.
The data sets can be displayed in the report you create in your requested format.

Good luck
Tal.

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.