What's the best tool for creating this report?
For a specific project area, I would like a report that shows, for each change set, it's work items, streams its been delivered to, and stream builds that picked up the change set.
Is this something that would have to be done with the RTC plain Java API, or could it be done with BIRT, the REST service, or some other available reporting product?
One answer
Have you looked into Rational Publishing Engine? It allows you to create document reports that parse data from the XML results of the Reporting REST API.
Here is the information on the scm data availible in the REST API. You should be able to pull the information you're looking for from this interface.
https://jazz.net/wiki/bin/view/Main/ReportsRESTAPI#scm
Comments
I didn't see the information Mark was requesting in that RESTAPI (i.e., the work items associated with a change set, the streams containing the change set, or the builds containing a change set). Where would they be found in the documented RESTAPI?
(One can obtain this information through the Java API).