Fixing TFS reports after an upgrade/migration to TFS 2008

Microsoft has made quite a few changes to reports in TFS 2008. As you can see form the table below in TFS 2008 we do not only have 6 new reports, but some of the existing reports have been modified/removed (new reports are in red, removed reports are in orange).

This means that when you upgrade/migrate to Team Foundation Server 2008, your reports will no longer work as the schema has changed. To resolve the issue you need to download the new process template (http://msdn2.microsoft.com/en-us/teamsystem/aa718795.aspx) and add or update your reports on TFS server.

To add new report:

1. Go to your Reports server (http:// [SERVERNAME] /reports)
2. Click on Upload file
3. Browse to the report file (.rdl) you want to upload and click OK to upload
4. Click on newly uploaded report file and click on Properties
5. Set up data sources by clicking on Data Sources (Don't forget to click Apply button)
6. Depending on report, you might also have to set up default parameters by clicking on Parameters (Don't forget to click Apply button)
7. Click on View to make sure that report is displaying properly

To update existing report:

1. Go to your Reports server (http:// [SERVERNAME] /reports)
2. Click on report that you want to update and click on Properties
3. Click on Update
4. Browse to the report file (.rdl) you want to upload and click OK to upload
5. Make sure that data sources are configured properly by clicking on Data Sources (Don't forget to click Apply button)
6. Depending on report, you might also have to set up default parameters by clicking on Parameters (Don't forget to click Apply button)
7. Click on View to make sure that report is displaying properly

Note: You will have to update reports for each TFS project