Browse by Tags
All Tags »
Reports (
RSS)
Problem: I was approached by my friend Nimrod Stern to help him with a problem he had regarding TFS reports. When trying to open a TFS report the following error was received: An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'dsIteration'. (rsErrorExecutingCommand) Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP...
When we Change an Existing TFS 2010 Report and upload it to the ‘TFS report site’ in order to add it to a specific team project ( How to Add TFS 2010 Report to a Team Project ) we many times want to change the default parameters of that report. If you try to add default values of a parameter it should work when you’ll upload the new report to the report site and you will see the changes. if you try to delete one of the default values, when you upload the file you will not see the changes. The...
Sometimes the default reports that come with the TFS process templates are not 100% compatible with the clients needs or desires. Luckily for us these reports can be changed customized as we wish. 1) First of all we must open the process template manager, and download the same process template that the team project in which we want to change the report uses. 2) Do steps 1 to 4 from this post How to Add TFS 2010 Report to a Team Project . 3) After these steps instead of creating a new report...
Sometimes the reports that come with TFS 2010 are not enough and we want to create are own custom reports. Beside creating the report itself there is a process of Adding it to a specific Team Project. This can done easily with a few simple steps: 1) First of all open “SQL Server 2008 Business Intelligence Development Studio”. 2) In the studio open a new report Project. 3) Add a data source to the project. 4) Set the data source to your local TFS data base. 5) Add a report...
I was asked to create a TFS report that will show all the changes that where made in “Requirement” work items in the last tow weeks. The problem was that I didn’t want to see columns that are empty… What I did is to take from the data base everything, but if one of the columns das not hold any changes(data) it will simply be hidden. Example: I have a report that one of the columns returned no values, but it might next time. I would like to hide this column only when it is empty in all the...