Locating Reports After the Upgrade to Team Foundation Server 2010

  • Article

Upgrading your Team Foundation deployment to Visual Studio Team Foundation Server 2010 introduces several changes that affect the location and operations of reports that are accessed through SQL Server Reporting Services. Specifically, you will have access to both pre-existing or pre-upgrade reports, and new or post-upgrade reports that are based on the data warehouse schema for Team Foundation Server 2010.

The following are the immediate effects that you will notice:

  • If your upgraded team project was based on version 4.2 of a Microsoft Solutions Framework (MSF) process template, you have access to a set of post-upgrade reports. These reports can be accessed from the Report Reports node in Team Explorer or from the Reports link in Team Web Access.

  • You cannot access pre-upgrade reports from the Report node in Team Explorer or from Team Web Access. You can still access pre-existing reports from a Web browser.

  • Data that has been added since the upgrade does not appear in pre-existing reports. All new data flows into the new data warehouse that was created during the upgrade. All pre-existing data is maintained in a data warehouse that is based on the earlier schemas.

To view a pre-upgrade report, you may have to modify it to address changes that were introduced by SQL Server 2008. To use a pre-upgrade report to support reporting on your upgraded team project, you must modify each report to connect to the new data warehouse and address the schema changes that were introduced by Team Foundation Server 2010.

In this topic

  • Two Sets of Data Warehouse Resources

  • Team Project Collections and Report Location Hierarchy

  • Viewing Post-Upgrade Reports

  • Viewing Pre-Upgrade Reports

Two Sets of Data Warehouse Resources

The upgrade to Team Foundation Server 2010 introduces two sets of data warehouse resources. As shown in the following illustration, there are two data warehouse relational databases and two SQL Server Analysis Services cubes.

Two sets of reports and two report locations

The following table lists the names that are automatically assigned to the Reporting Services data resources that are used by reports.

Database resource

Name assigned to resources based on earlier versions of Team Foundation Server

Name assigned to resources for Team Foundation Server 2010

Data warehouse relational database

TfsReportsDS

Tfs2010ReportsDS

Analysis Services cube

TfsOlapReportsDS

Tfs2010OlapReportsDS

The 2010-based names support the upgrade of a server where you have an existing set of reports that were designed to work with schemas that were designed for Visual Studio 2005 Team Foundation Server or Team System 2008 Team Foundation Server. An upgrade to Team Foundation Server 2010 creates a new warehouse and cube that use a different schema that is incompatible with the previous data warehouses. The new data sources point to the new warehouse and cube and leave the previous data sources intact.

You can continue to view pre-upgrade reports. However, no new data will be added to the pre-upgrade data warehouse and cube. The use of new data source names allows the pre-upgrade reports (which use the old data sources) to continue to render pre-upgrade data.

Team Project Collections and Report Hierarchy

With the introduction of team project collections and report folders, reports are now organized on the server that hosts Reporting Services in a hierarchy that resembles the following:

TfsReports > Project Collection > Team Project > Report Folder > Report

The following illustration shows this structure for the project that is named Dev10Demo.

SQL Server Reporting Services

Viewing Post-Upgrade Reports

To view post-upgrade reports

  1. Open Internet Explorer, type the following string in the Address bar, and press ENTER:

    http://ReportServerName/TFSReports/ProjectCollectionName/ProjectName/

    If you have deployed a named instance on the data-tier server, type the following string instead:

    http://ReportServerName/TFSReports_TFSInstance/ProjectCollectionName/ProjectName/

  2. Click the folder that contains the report that you want to view.

  3. Click the report that you want to view.

Viewing Pre-Upgrade Reports

To view pre-upgrade reports

  1. Open Internet Explorer, type the following string in the Address bar, and then press ENTER:

    http://ReportServerName/Reports/ProjectName/.

    If you have deployed a named instance on the data-tier server, type the following string instead:

    http://ReportServerName/Reports_TFSInstance/ProjectName/

  2. Click the report that you want to view.

See Also

Tasks

Manage Reports

Concepts

Creating, Customizing, and Managing Reports for Visual Studio ALM

Updating an Upgraded Team Project to Access New Features

Other Resources

Reports (Agile)