How to Create a New Report in Visual Studio

- J.D. Meier, Jason Taylor, Alex Mackman, Prashant Bansode

You can create reports by using the SQL Server 2005 Reporting Services Designer inside Visual Studio (Business Intelligence Development Studio), which ships with the SQL Server 2005 client tools.

Create a new report if there are no existing reports that can be modified to meet your needs. Modifying an existing report is often easier than creating a new report.

To create a new report in TFS
  1. Create a reporting project as follows:
    1. In Visual Studio, click File, click New, and then click Project.
    2. Select the Business Intelligence Project type.
    3. Select the Report Server Project template.
    4. Set your project’s Name and Location and then click OK.
  2. Add data sources as follows:
    1. To create the warehouse data source:
      1. In Visual Studio Solution Explorer, right-click Shared Data Sources and then click Add New Data Source.
      2. On the General tab, in the Name text box, type TfsReportDS
      3. In the Type combo box, select Microsoft SQL Server.
      4. Click Edit.
      5. Fill in your data tier server name.
      6. Select the TFSWarehouse database.
      7. Click the OK button twice to add the data source.
    2. To create the Online Analytical Processing (OLAP) data source:
      1. In Solution Explorer, right-click Shared Data Sources and then click Add New Data Source.
      2. On the General tab, in the Name text box, type TfsOlapReportDS
      3. In the Type combo box, select Microsoft SQL Server Analysis Services.
      4. Click Edit.
      5. Fill in your data tier server name.
      6. Select the TFSWarehouse database.
      7. Click the OK button twice to add the data source.
  3. Create a new report as follows:
    1. In Solution Explorer, right-click Reports, point to Add,** and then click* New Item*.
    2. Select the Report template.
    3. Name the report and then click OK.
  4. Modify the report as follows:
    1. If the Report Designer does not open automatically, open the report for modification by double-clicking it in Solution Explorer.
    2. In the Dataset drop-down list, select <New Dataset...>.
    3. Name the dataset; for example TestDataSet.
    4. Select TFSOlapReportDS (shared).
    5. Click OK.
    6. Click the ellipsis (...) button next to Build (just below the Dataset drop-down list), and then select Team System.

You can now modify your report by dragging measures and dimensions from the Dataset tree into the Query Pane and Filter Pane.** You can modify the report’s layout by clicking the Layout tab. You can preview your report by clicking the Preview tab.

Note: Although you** can use the Report Builder that is available from the team reporting site, this tool is not well supported for Visual Studio reporting scenarios and therefore is not recommended.

Additional Resources

  • For more information, see “How To – Create a Custom Report for Visual Studio Team Foundation Server” in this guide.

Last edited Jul 25, 2007 at 10:50 AM by prashantbansode, version 1

Comments

No comments yet.