RTC custom contributors on top of custom text fields to add on BIRT Report

I was able to get this to work and this is how.

1. Create a data source to Live_Snapshot

2. Create a new "Simple" Data set. 

a. Set data source to Live_Snapshot

b Set Table Name: com.ibm.team.workitem.WorkItem

c. Select columns: itemExtensions.value.itemId

d. Select parameters:

itemId: This can be defaulted to a known WI_ITEMID of a Work Item for testing

workItemType = hard code to work item type

itemExtensions.key: hard code to the name of the work item field holding the contributor

3. Create a new Simple Data Set

a. Set Data Source = Common_Shapshot

b. Select columns: Contributor_Itemid, Contributor_Name

c. Select parameters: Contributor_ItemID  This can be defaulted to a known CONTRIBUTOR_ITEMID for testing purposes

4. Create a Join Query that joins data set in 2 on the left to data set in 3 on the right

Do a left outer join and join itemExtensins.value.itemId to Contributor_Itemid

5. In your report, add the join data set in 4 to the column for the custom contributor

6. Do a parameter binding as follows:

a. Bind the itemid to the WI_ItemID

b. Remove the extra column, header and footer from this nested table

You now have the custom attribute contributor listed on your report.