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.
If you run that attached template file on your TFS server it will correct the problem. The attached file will need to be opened and run within “SQL Server Management Studio” and, as it is a template file, you will need to specify some parameters. To do this use the key combination [crtl]+[shift]+[m], prior to execution.