BIRT Report Designer, can't find Work Item comments?
![](http://jazz.net/_images/myphoto/1a1c3766c4729aa468c4ad84f520e6df.jpg)
Hello,
The title says it all, I can't find the comments associated to a Work Item that I specified in RTC through the "Discussion" field, I am looking for that information from the Report Designer of course?
Displaying the Work Item comments in reports doesn't sound inapropriate, there must be a way to access this information some how.
Any ideas will be appreciated.
By the way, I use RTC 1.0.1
Thanks
The title says it all, I can't find the comments associated to a Work Item that I specified in RTC through the "Discussion" field, I am looking for that information from the Report Designer of course?
Displaying the Work Item comments in reports doesn't sound inapropriate, there must be a way to access this information some how.
Any ideas will be appreciated.
By the way, I use RTC 1.0.1
Thanks
7 answers
![](http://jazz.net/_images/myphoto/1a1c3766c4729aa468c4ad84f520e6df.jpg)
A workaround for getting custom column in a query is to use the export function the RTC thick client.
Go into the Work Item Perspective and select export from the file menu.
When the export window opens, browse into "Team" and select "Work Items".
The "Export Work Item" window will open. Select "Browse" next to the Query box to browse for and select the Work Item query that you wish to use. Select the format and destination as required.
Now the "Export Work Items" window will be displayed. Press the "Add columns" button.
The "Add Columns" window will open which enables you to select any of the columns in the work item, including the ones not available in the normal work item query.
If you also select "Show Custom" you can also select any of you custom columns to be displayed. Note that the "Comments" column is the content of the discussion field in the work item. Select the columns you want to a add into your report and hit ok. Do a "Ctrl-Click" to select multiple columns.
You will return to the "Export Work Items" windows. You can now remove or reorder columns. When you are ready to go hit finish and you report file will be created, including columns not normally available in queries.
Go into the Work Item Perspective and select export from the file menu.
When the export window opens, browse into "Team" and select "Work Items".
The "Export Work Item" window will open. Select "Browse" next to the Query box to browse for and select the Work Item query that you wish to use. Select the format and destination as required.
Now the "Export Work Items" window will be displayed. Press the "Add columns" button.
The "Add Columns" window will open which enables you to select any of the columns in the work item, including the ones not available in the normal work item query.
If you also select "Show Custom" you can also select any of you custom columns to be displayed. Note that the "Comments" column is the content of the discussion field in the work item. Select the columns you want to a add into your report and hit ok. Do a "Ctrl-Click" to select multiple columns.
You will return to the "Export Work Items" windows. You can now remove or reorder columns. When you are ready to go hit finish and you report file will be created, including columns not normally available in queries.