index > Team Foundation Server - Reporting > Reporting on Plain Text Fields in Work Items

Reporting on Plain Text Fields in Work Items

Hello. I'm relatively new to the TFS game, but my company is jumping in with both feet, so I'm trying to get up speed. Anyway....I've modifed both the Task and Bug work items to include a Release Notes field (type is PlainText), and I would like to create a report that pulls the release notes for a particular iteration. I've discovered that PlainText fields cannot be put into the data warehouse, so I'm wondering if there is a solution to reporting on long text fields outside of simply writing a query for a report that spans the various TFS databases.

brian_j

Hi Brian,

Welcome aboard!

The biggest type that can go into the warehouse is a String, so you're right that PlainText cannot be put into the warehouse. Another option to querying the Work Item Tracking database is to link to the work item details web page from your report -- this is if you dont mind having to click for more details. You can look at the Work Items report to see how to do this. If you want all the details on one page, what you suggest is a good solution.

Mauli

Mauli Shah - MSFT

reply 2

You can use google to search for other answers

More Articles

·Report with item description

·The synchronization issue of the reporting

·Failed to load adapter

·Can't Create New Projects - Help Please?

·Code Reviewer Report

·reports not showing up on home page

·How do I set default value for a dimension variable to a value ot...

·Error in Reporting

·How do I fix the TfsOlapReportDS user problem?

·Checkin Policy Override Report

Welcome to Bokebb New Update Joins the collection

New Articles

·How can I create Dynamic Query between t��
·is there any where, where i can get how ��
·How do I create a new QA Report in Team ��
·Adding Data Region to existing items
·Issues with dimension after following wa��
·Build metrics
·More Warehouse problems
·Unplanned work report incorrect
·Source Control Reporting
·Retrieving System.Description Field Data
·When trying to add a new VS2005 RDL file��
·replicate cool history tab in report
·SQL SP1 killed some reports
·"Hidden" reports in RTM ..
·Reports not accessible through project p��

Hot Articles

·Report with item description
·Why there is a fork icon in my report fo��
·How to recreate the TFSWarehouse Databas��
·Reporting Services Error
·msmdsrv using 50% cpu for minutes
·Error in Customising a existing report
·How can I report developer hours by week?
·Report server problem.
·Can't get access to reports if the data ��
·Datagrid row style
·Creating an OLTP datasource for writing ��
·How do i edit or delete reports?
·Error al procesar el informe. (rsProcess��
·How to get "Current Week" in M��
·Reporting on Plain Text Fields in Work I��

Recommend Articles

·Source Control Reporting
·Retrieving System.Description Field Data
·Report parameters problems
·TfsWarehouse Database not updated with a��
·How to prevent users from viewing other ��
·Error when trying to display a report
·Trouble with VSTS / Sharepoint remoting ��
·AssignedTo names in reports
·"Hidden" reports in RTM ..
·ReportServer asking for username and pas��
·Code Reviewer Report
·How is unplanned work report calculated?
·Having trouble deploying to the report s��
·custom views in TFSWarehouse
·Requirements Test History and Overview n��