Creating and Managing Reporting Services Reports for Visual Studio ALM
You can create and manage reports that use SQL Server Reporting Services to analyze the progress and quality of your project. You can access these reports from the Reports node in Team Explorer, from Team Web Access, or from the Reports link on the team project portal.
Access to these reports requires that the team project collection that hosts your team project has been provisioned with Reporting Services. Access to the SQL Server Analysis Services cube requires that the deployment of Visual Studio Team Foundation Server has been provisioned with Analysis Services.
You can create reports for Reporting Services by using Report Builder 2.0 or Report Designer:
Report Builder 2.0 is an intuitive environment for authoring reports. This application is optimized for Microsoft Office so that business users can work in that familiar environment. You can use Report Builder 2.0 to work with data, define a layout, preview a report, and publish a report to a report server or a SharePoint site. This application includes a wizard for creating tables or charts, in addition to query builders and an expression editor. It also supports the advanced reporting features in SQL Server 2008 Reporting Services.
You can download Report Builder for free from the following page on the Microsoft Web site: Microsoft SQL Server 2008 Reporting Services Report Builder 2.0.
Report Designer is a graphical interface for creating full-featured Reporting Services reports. After your report is finished, you have access to the full functionality for managing Reporting Services reports. To use Report Designer, you must know how to connect to and query a data source, but you do not have to know Report Definition Language (RDL).
To use Report Designer, you must have Visual Studio and SQL Server Business Intelligence Development Studio.
You can access both the relational data warehouse and the Analysis Services cube to create highly customized reports by using these authoring tools. For more information, see Additional Resources.
View, upload, and organize reports. You can use Team Explorer, Team Web Access, or Report Manager to access and manage reports and create and rename report folders.
Define a report project in Visual Studio. The first step in creating a report in Report Designer is to create a report server project.
Generate reports from the OLAP data cube. By using Report Designer, you can create an aggregate report that accesses data that is stored in the Analysis Services cube.
Generate reports from data in the relational data warehouse. By using Report Designer, you can create a detailed report that accesses data that is stored in the relational data warehouse.
Manage report properties. After you create and publish reports, you can use Report Manager to view, organize, and configure those reports. By using Report Manager, you can group related reports in folders, adjust parameters and data sources, and schedule automated reports.
Review the default reports. You may be able to use or customize an existing report. Also, by reviewing the reports that were provided with your process template, you will gain an understanding of the types of reports that are available and how you may want to share them.
Add resources to existing team project collections. You can add Reporting Services to a team project collection after you create it.
You can learn more about how to work with authoring tools for Reporting Services from the following pages on the Microsoft Web site: