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 |
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, |
|
Hi,
I got a solution of using the Group on WI_ID and aggregation on the dates using filter conditions on the Dates fields. Thanks Dhanya |