Share via

Reporting Services Tutorials

Microsoft SQL Server 2005 Reporting Services (SSRS) includes tutorials that you can use to learn basic skills one step at a time.

  • Reporting Services Tools
    Provides an introduction to the Reporting Services Configuration tool, Report Manager, Report Builder, Report Designer, and Model Designer by showing you how to locate and open each tool.
  • Creating a Basic Report
    Follow the steps in this tutorial to learn how to create your first report. This tutorial shows you how to work with Report Designer to create a data source connection, define a simple query, and build a layout to contain your data.
  • Advanced Features Using Parameters
    This tutorial shows you how to add cascading parameters, work with multivalue parameters, and how to pass parameters to subreports, linked reports, and drillthrough reports.
  • Using XML Data in a Report
    You can build reports that retrieve data from an XML Web service. This tutorial explains how to configure the connection, define the dataset, and return query results.


Some tutorials require specific editions of SQL Server. For example, model functionality is available in the Standard, Developer, and Enterprise Editions, but not in SQL Server 2005 Express with Advanced Services. Edition requirements are noted in the requirements section of each tutorial.

Some of the tutorials use the Reporting Services sample reports and databases. The samples are not installed automatically during setup, but you can install them at any time. For information about installing the samples, see Installing Samples.

See Also

Other Resources

SQL Server Reporting Services Samples
Designing and Creating Reports
AdventureWorks Sample OLTP Database
Report Samples (Reporting Services)
Working with Models

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

17 July 2006

New content:
  • New Report Model tutorials
  • Parameter tutorials
  • Reporting Services tools
  • Updating reports using the RDL schema
  • Instructions for installing sample databases
Changed content:
  • Using XML Data

14 April 2006

New content:
  • New Report Model tutorials.