How to add BIRT custom report widget in IBM RTC

Basically , you can follow this link for custom BIRT report in IBM RTC. But I found it still need some tricky notes for completing my request. First, I need to add RTC custom field and its type is large string or html. Second, I need to add this custom BIRT report as Dashboard report widget . Please follow my notes as below :

1. Normally , you can use LIVE_WORKITEM_CNT as data set to retrieve RTC fields, but NOT for Large String and HTML 

2. How to get your custom fields in RTC ? Use STRING_KEY/STRING_VAL (INTEGER/LONG as well) to retrieve your RTC custom filed . Select STRING_VAL column with STRING_KEY parameter

3. How about the Large String Val ? you can NOT find it within LIVE_WORKITEM_CNT , . You have to retrieve it through WORKITEM_EXTRA_DATA  (including DESCRIPTION field):

4. Then you have to use BIRT techniques to fetch those two datasets, you can follow this link to get hints.implemented as below : Key is to bind parameter to master data set ID: (row["WI_ID"])

 5. You can adjust page layout ( width/height) in the Master Page tab (type dropdown list).

 6.After upload your rptdesign file , It's easy to show report .BUT how to add report in the Dashboard ? After lots of failed tries, follow this link  , my report displayed well in the dashboard ! . 

Note : 

• The existing common report viewlet definition ID must be used: com.ibm.team.reports.viewlet
• Report ID is " report resource identifier value ", you can find it in report resource (edit mode)

7. Add Hyperlink to workitem detail :
Hyperlink to view a work item (com.ibm.team.workitem.viewWorkItem)

To view a singlework item, use a hyperlink like:

"#action=com.ibm.team.workitem.viewWorkItem&id=" + id;

where id is the id of the work item.

8. Adjust Layout settings :
     You can set the layout to "auto layout" as below, then all the fields will be adjusted by BIRT.

  if you use the "Fixed Layout", then you have to control the cell content by yourself with scripts. Below script is for your reference. (You have to define the onRender() event for the specific column object you want to auto-break (ex:WeeklyUpdate)

---------------------------------------------------------------

var name = this.getValue();   

name = name.toString();   

var interval = 35;// Set the page break words number

var n = name.length() / interval|0;   

var re =  name.length() % interval;   

var rslt = "";   

for(var i=0; i<n; i++){   

  var subs = name.substr(i*interval,interval);   

  rslt += ( subs + "\n");   

}   

if(re > 0){   

  rslt += name.substr(n*interval,re);   

}   

this.setDisplayValue(rslt);   

-----------------------------------------------------------------------