Share via

Tutorial: Creating a Basic Report

This tutorial is designed to help you create a basic table report based on the AdventureWorks 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, and preview the report.


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

  • Microsoft SQL Server 2005 Reporting Services.


    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 Deployment Modes for Reporting Services. For more information about deploying projects, see Deploying Reports, Models, and Shared Data Sources to a SharePoint Site.

  • SQL Server 2005 with the AdventureWorks database. For more information about installing sample databases, see Installing Samples. For information about the SQL Server 2005 Express Edition with Advanced Services samples, see Installing Sample Databases for Express Editions.

  • SQL Server 2005 Business Intelligence Development Studio.


    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 permissions to retrieve data from the AdventureWorks database.


Lesson 1: Creating a Report Server Project

Lesson 2: Setting Up Connection Information

Lesson 3: Defining a Query for the Report

Lesson 4: Adding a Table Data Region

Lesson 5: Previewing the Basic Report


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

See Also


Reporting Services Tutorials

Other Resources

Report Builder
Creating a Report Using Report Wizard
Report Samples (Reporting Services)
Installing AdventureWorks Sample Databases and Samples

Help and Information

Getting SQL Server 2005 Assistance