How to: Create a Report Server Project for Team System

  • Article

You can track your team's progress by using Report Designer to create reports. Before you can base these reports on data from Team System, you must first create a Report Server project in Visual Studio.

For an overview of Report Designer, see Working With Report Designer on the Microsoft Web site. For more information about how to create Team System reports in Report Designer, see How to: Create a Detailed Report for Team System using Report Designer and How to: Create an Aggregate Report for Team System using Report Designer.

Prerequisites

To perform this procedure, you must have Visual Studio 2005 and SQL Server 2005 Business Intelligence Development Studio.

Note

To install Business Intelligence Development Studio, run the Setup program for , and select the Client Components check box when you specify the components to install. To install the most recent service pack for , see "How to obtain the latest service pack for SQL Server 2005" on the Microsoft Web site.

Required Permission

To use the connections that you create in these procedures, you must be a member of the TfsWarehouseDataReaders security roles in both the relational and analysis services databases of the warehouse for Team System. For more information, see How to: Grant Access to the Databases of the Data Warehouse for Team System.

To create a Reporting Server project

  1. In Visual Studio, open the File menu, point to New, and then click Project.

    The New Project dialog box appears.

  2. Under Project types, click Business Intelligence Projects.

    Note

    If Business Intelligence Projects does not appear in the list of project types, you must install SQL Server 2005 Business Intelligence Development Studio. For more information, see the Prerequisites section near the start of this topic.

  3. Under Templates, click Report Server Project.

  4. In the Name box, type a name for the project, and then click OK.

To create the TfsReportDS and TfsOlapReportDS data sources

  1. On the Project menu, click Add New Item.

    The Add New Item dialog box appears.

  2. Click Data Source, and then click Add.

    The Shared Data Source dialog box appears.

  3. In the Name box, type TfsReportDS.

    Important

    If you do not use the name specified in this step, the procedures for deploying your reports will not work properly. This procedure creates local copies of the data sources that you will use as you develop your reports. These copies are equivalent to data sources that Team Foundation Server has created on the Reporting Services server. When you deploy a report, Team Foundation Server will use the data source on the server that has the same name as your local copy of the data source in your project.

  4. In the Type list, click Microsoft SQL Server, and then click Edit.

  5. In the Connection Properties dialog box, type the name of the server that hosts the data warehouse for Team System, and then click Use Windows Authentication.

    Note

    In a typical configuration, use the name of the data-tier server. However, the warehouse can also be hosted on a separate server.

  6. Click Select or Enter a database name, and then click TFSWarehouse.

  7. (Optional) Click Test Connection to verify that the connection works as defined, and then click OK to return to the Shared Data Source dialog box.

  8. Click OK, and then click OK to create the data source.

  9. Repeat steps 1-7 to create another data source. Specify Microsoft SQL Server Analysis Services for the type of the data source, and name it TfsOlapReportDS.

To set the project's properties so that you can deploy reports

  1. On the Project menu, click Properties.

  2. For the value of the OverwriteDataSources property, click False.

    Note

    If you set this option, you can publish your reports without overwriting the data sources on the server with those that you defined in this project.

  3. For the value of the TargetDataSourceFolder property, type /.

  4. For the value of the TargetReportFolder property, type the path of the folder where you will deploy the reports from this project. If you will deploy the reports to a specific team project, use the name of the team project.

  5. For the value of the TargetServerURL property, type the URL of the Reporting Services server. For example, you can type https://DataTierServer/reportserver.

See Also

Tasks

How to: Create an Aggregate Report for Team System using Report Designer
How to: Set Project Lead Permissions for Team Foundation Server

Other Resources

How to: Create a Detailed Report for Team System using Report Designer
Getting Started With Custom Reports for Team System
Managing Reports in Team Explorer
Visual Studio Team System Glossary