Pulling the data from Work_item_extra_data table
1) Iam trying to generate a simple report to get the work item and its description, I am trying to use Work_item_extra_data table for it, when ever I try preview the results I get BIRT exception occured error
2)I also want to combine the 2 data sets, I mean the data from Work_item_extra_data table and live_work_item_cnt table to to get the report that has the following columns:
WI_id, Summary, Description, Team Area, duration etc.,, the only reason I need to join these tables is to get the Description column value.
Can someone please help me with this please
2)I also want to combine the 2 data sets, I mean the data from Work_item_extra_data table and live_work_item_cnt table to to get the report that has the following columns:
WI_id, Summary, Description, Team Area, duration etc.,, the only reason I need to join these tables is to get the Description column value.
Can someone please help me with this please
2 answers
On 5/7/2010 12:53 PM, ghkr_2000 wrote:
What is the BIRT exception? What version of RTC client and server are
you using?
Don't simply use a joint data set on those two tables - it will fetch
large amounts of data and join them in memory (Rather than using a
database join). A more efficient approach would be to fetch the
live_workitem_cnt data set first and create a table from it. Then,
inside the table, drop the row from the workitem_Extra_Data table and
bind its parameter to the work item ID for that particular table row.
Hope this helps.
james
RTC Reports Team Lead
1) Iam trying to generate a simple report to get the work item and its
description, I am trying to use Work_item_extra_data table for it,
when ever I try preview the results I get BIRT exception occured
error
What is the BIRT exception? What version of RTC client and server are
you using?
2)I also want to combine the 2 data sets, I mean the data from
Work_item_extra_data table and live_work_item_cnt table to to get the
report that has the following columns:
WI_id, Summary, Description, Team Area, duration etc.,, the only
reason I need to join these tables is to get the Description column
value.
Can someone please help me with this please
Don't simply use a joint data set on those two tables - it will fetch
large amounts of data and join them in memory (Rather than using a
database join). A more efficient approach would be to fetch the
live_workitem_cnt data set first and create a table from it. Then,
inside the table, drop the row from the workitem_Extra_Data table and
bind its parameter to the work item ID for that particular table row.
Hope this helps.
james
RTC Reports Team Lead
On 5/7/2010 12:53 PM, ghkr_2000 wrote:
1) Iam trying to generate a simple report to get the work item and its
description, I am trying to use Work_item_extra_data table for it,
when ever I try preview the results I get BIRT exception occured
error
What is the BIRT exception? What version of RTC client and server are
you using?
2)I also want to combine the 2 data sets, I mean the data from
Work_item_extra_data table and live_work_item_cnt table to to get the
report that has the following columns:
WI_id, Summary, Description, Team Area, duration etc.,, the only
reason I need to join these tables is to get the Description column
value.
Can someone please help me with this please
Don't simply use a joint data set on those two tables - it will fetch
large amounts of data and join them in memory (Rather than using a
database join). A more efficient approach would be to fetch the
live_workitem_cnt data set first and create a table from it. Then,
inside the table, drop the row from the workitem_Extra_Data table and
bind its parameter to the work item ID for that particular table row.
Hope this helps.
james
RTC Reports Team Lead
Hi James,
I want to display the information given in "Discussion" of a work item in a report. How can I do this?.. Any info?
Prasad R Rachuri