Last week, I had the following situation at a customer: There was a dual-tier TFS 2010 installation without reporting and analysis services. The customer did already create some Team Projects, and now they wanted to activate the reporting and analysis functionality. Ok, no problem at all. First installing the SQL Server 2008 R2 reporting and analysis functionality on the application tier and then link the reporting and analysis services to the data tier (where all database are stored, so the services do run on the application tier, and the data is stored on the data tier).
After the installation of the services, we wanted to upgrade our existing team projects to make use of the reporting functionality. There is a way to do this manually, like described in this post, but this is really hard. You have to download your process template, create the correct mapping on your reporting server, upload ‘all’ reports (for each team project), divide them in correct folders,..
There is a better way, use the TFS Power Tools. Just install the Power Tools on your application tier, and open a command prompt. If you enter ‘tfpt’, you should see a list of all the commands you can use with the Power Tools.
One of the cool features you have is ‘addprojectreports’. This will add or overwrite all reports of a team project with the reports from your selected process template. In our case, the team project does not have any reports (yet), so we want to add the ‘ MSF for Agile Software Development v5.0’ reports. We can simply do this using the command:
tfpt addprojectreports /collection:http://TFS_Instance:8080/tfs/DefaultCollection /teamproject:"TheProject" /processtemplate:" MSF for Agile Software Development v5.0" /force
All you have to do is supply your TFS instance, the team project name and the process template name you want the reports from. After executing this command, you have your reporting linked to your team project. Note: Be sure that your team project collection has a folder on the report server (http://your_reportserver/Reports) like ‘TfsReports/DefaultCollection”, and that you link this folder to your reports section of your team project collection in the TFS administration Console.
To make use of your reporting, all you have to do is rebuild your analysis cube using the administration console ‘Start Rebuild’ button in the reporting section. Have fun!
(You can also use the Power Tools to create a SharePoint project portal using the command: tfpt addprojectportal)