Tutorial: Creating a Basic Table Report

SQL Server 2008 Books Online (October 2009)

This tutorial is designed to help you create a basic table report based on the AdventureWorks2008 database using Report Designer. You can also use Report Builder or the Report Wizard to create reports. In this tutorial, you will create a report project, set up connection information, define a query, add a Table data region, group and total some fields, and preview the report.

Note:
To complete this tutorial, you must be running Reporting Services in native mode. If you are running Reporting Services in SharePoint integrated mode, the steps that use report server URLs will not work. For more information about Reporting Services modes, see Planning a Deployment Mode. For more information about deploying projects, see Deploying Models and Shared Data Sources to a SharePoint Site.

Note:

To complete this tutorial, you must be running Reporting Services in native mode. If you are running Reporting Services in SharePoint integrated mode, the steps that use report server URLs will not work. For more information about Reporting Services modes, see Planning a Deployment Mode. For more information about deploying projects, see Deploying Models and Shared Data Sources to a SharePoint Site.

Requirements

Your system must have the following installed to use this tutorial:

Microsoft SQL Server 2008 with the AdventureWorks2008 database installed. SQL Server 2008 samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases. To read about support for SQL Server sample databases and sample code for SQL Server Express, see Databases and Samples Overview on the CodePlex Web site.
SQL Server 2008 Reporting Services (SSRS).

SQL Server Business Intelligence Development Studio.

Note:
Business Intelligence (BI) Development Studio is not supported on Itanium-based computers. However, support for BI Development Studio is available for x64-based computers. If the SQL Server sample databases have been deployed on an Itanium-based computer, use BI Development Studio on either an x86-based or x64-based computer to modify and run the samples.

You must also have read-only permissions to retrieve data from the AdventureWorks2008 database.

Tasks

Lesson 1: Creating a Report Server Project (Reporting Services)

Lesson 2: Specifying Connection Information (Reporting Services)

Lesson 3: Defining a Dataset for the Table Report (Reporting Services)

Lesson 4: Adding a Table to the Report (Reporting Services)

Lesson 5: Formatting a Report (Reporting Services)

Lesson 6: Adding Grouping and Totals (Reporting Services)

Note:
When reviewing tutorials, it is recommended that you add next and previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

Concepts

Other Resources

Help and Information