BIRT create report - List workitems included in more than one project
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.
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
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/
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.
The data sets can be displayed in the report you create in your requested format.
Good luck
Tal.