index > Team Foundation Server - Reporting > Report with item description

Report with item description


I need a report which shows the scenario descriptions along with the other data. The description field turns out to not be "reportable" in the field definitions. How do I do this?
vbykin

The work item descriptions are, as you have discovered, not reportable items. This is because they can be quite large. As the work item is edited it can become pages. Consider using the Title in your report instead and possibly having a "drill through" to the longer description.

As an example of a report with the full work item linked see the "Bugs Found Without Corresponding Tests" report. The work item data can be accessed via: http://<Your Report Server>:8080/WorkItemTracking/Workitem.aspx?artifactMoniker=<Work Item ID>

The work item descriptions are stored in the [TfsWorkItemTracking].[dbo].[WorkItemLongTexts] table. Please keep in mind that, when and if you upgrade, you may need to slightly modify any reports you create that are backed by the TfsWorkItemTracking database.

Nick Ericson - MSFT
reply 2

You can use google to search for other answers

 

More Articles

Can't find links between Work item and test in the TfsWarehouse
TFS reporting
Reporting Services Error
TFS Analysys Services service stops all the time
table pagination
Can't find "Comments" of my manual test in my Team syst...
The synchronization issue of the reporting
Code churn == Non binary churn?
NullReferenceException during Code Churn Calculation
report stops showing data - warehouse not update
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Failed to load adapter
Error in Customising a existing report
Using Excel pivot charts, can I filter o…
No report image in Project Portal, but d…
Retrieving System.Description Field Data
How to accss Symptom and StepsToReproduc…
Problem with WI's and reportable="d…
rsRenderingExtensionNotFound
Another warehouse not updating :( - now …
How do I fix the TfsOlapReportDS user pr…
ReportServer asking for username and pas…
Reports are present after upgrade to RTM…
error uploading reports
Printing Reports from within Team Explorer
New Project -- Reports Not Working Immed…

Hot Articles

Quality Indicators Report
How the change in the data of Cube will …
Reporting on Plain Text Fields in Work I…
Scenarios With No Tasks
Error 28806. Something is wrong with Re…
Not all work items are displayed.
Workitem trends and filters
Having trouble deploying to the report s…
Setting default parameter for project in…
Reuse query definition in reports ?
urgent: Connection Problems
Another TFS Warehouse problem...
schedulingfinishdate error + how to add …
How do I set default value for a dimensi…
Reports against Version Control

Recommend Articles

Getting TFS Reports working again after …
Unplanned work report incorrect
how to create entirely new report
How do I fix the TfsOlapReportDS user pr…
TFS Project & Report Server ERrors
msmdsrv using 50% cpu for minutes
Error Executing reports
Reports not accessible through project p…
TFS and Reporting Services - Domain vs. …
Possible Bug in Warehouseadapter
Setting for URL in Reporting services
Recreate Reports
Can not find any Perspective other than …
Report parameters problems
how to produce reports using rs with fea…