Need help in Report designing - BIRT-RTC for custom fields

Hi,
I need some help in getting report for custom fields in RTC.
The particular report that I am currently trying is
- finding difference between Reported date and responded date for an Incident.
Here Incident is a custom WorkItem. Reported date and responded date are custom fields.
The data looks like below in Live_WorkItem_CNT table
WI ID TIMESTAMP_KEY TIMESTAMP_VAL
1416 com.ibm.gbs.workitem.workItemType.incident.reporteddate Dec 22, 2010
1416 com.ibm.gbs.workitem.workItemType.incident.respondeddate Dec 22, 2010
There will be many rows like this with two rows per WI_ID
I want to create one row out of these pair like the below
WI_ID Responded date Reported date
1416 Dec 22, 2010 Dec 22, 2010
Thanks
Dhanya
I need some help in getting report for custom fields in RTC.
The particular report that I am currently trying is
- finding difference between Reported date and responded date for an Incident.
Here Incident is a custom WorkItem. Reported date and responded date are custom fields.
The data looks like below in Live_WorkItem_CNT table
WI ID TIMESTAMP_KEY TIMESTAMP_VAL
1416 com.ibm.gbs.workitem.workItemType.incident.reporteddate Dec 22, 2010
1416 com.ibm.gbs.workitem.workItemType.incident.respondeddate Dec 22, 2010
There will be many rows like this with two rows per WI_ID
I want to create one row out of these pair like the below
WI_ID Responded date Reported date
1416 Dec 22, 2010 Dec 22, 2010
Thanks
Dhanya
2 answers

You can achieve this by creating two Data Sets with each of them selecting an either field and later having a join Data set of them. Hope it helps
Hi,
I need some help in getting report for custom fields in RTC.
The particular report that I am currently trying is
- finding difference between Reported date and responded date for an Incident.
Here Incident is a custom WorkItem. Reported date and responded date are custom fields.
The data looks like below in Live_WorkItem_CNT table
WI ID TIMESTAMP_KEY TIMESTAMP_VAL
1416 com.ibm.gbs.workitem.workItemType.incident.reporteddate Dec 22, 2010
1416 com.ibm.gbs.workitem.workItemType.incident.respondeddate Dec 22, 2010
There will be many rows like this with two rows per WI_ID
I want to create one row out of these pair like the below
WI_ID Responded date Reported date
1416 Dec 22, 2010 Dec 22, 2010
Thanks
Dhanya