Scrum for Team System - Task Board Report Fix

Scrum for Team System - Task Board Report

“One of our new reports within the Scrum for Team System template is the Task Board report.  This report will show the current status of the work items link to the sprint.

Most of the data for this report comes from the data warehouse, however to make this report and its drilldown report useful some of data needed to come from the transaction database.  The description of the work item, which used by the task board report, is long text data and is not transferred to the warehouse.

There is a scenario there the task board report could return the following error:

An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'ReportData'. (rsErrorExecutingCommand)
For more information about this error navigate to the report server on the local server machine, or enable remote errors

This error occurs when the user account selected (during the initial TFS setup process) for reporting, which is different to user account for the services,  does not have permission to access the tfsWorkItemTracking database.

…”

Click through to get the download and installation instructions… (I’m not sure if we’re having this issue or not, but better to be safe and record this here for future reference…)