Reporting Services Tutorials

Updated: 17 July 2006

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.

Adding Grouping, Sorting, and Formatting to a Basic Report

This tutorial builds on the previous tutorial by showing you how to group, sort, and format your report.

Adding Parameters to a Basic Tabular Report

This tutorial builds on the previous tutorial by showing you how to add parameters that control both appearance and content of a report.

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.

Tutorials for Report Server Administration

These tutorials are for report server administrators and content managers:

Creating a Data-Driven Subscription shows you how to create a data-driven subscription, which is a specialized form of report delivery that uses a query to get subscription data and preferences.

Setting Permissions in Reporting Services shows you how to create roles assignments that control access to report server content.

Tutorials for Ad Hoc Reporting

Ad hoc reporting starts with models that provide the metadata required to create reports in Report Builder. These tutorials show you how to build models using Model Designer and available Management Tools and create reports using Report Builder:

Creating a Report Model shows you how to create your first report model using data from the AdventureWorks database, set up connection information, define a view of the data source, define a report model, and publish the model to a report server.

Refining a Report Model in Model Designer shows you how to modify the model to make it easier to use in Report Builder. In this tutorial, you organize and format the data, and create new fields.

Creating a Report Model Based on an Analysis Services Cube shows how to create a report model based on your Analysis Services cube.

Applying Security Filters to Report Model Items shows you how to apply row-level security to model items.

Creating a Report Model-Based Query for Use in Report Designer uses the Report Model Query Designer in Report Designer to build queries using report models.

Customizing Report Builder Clickthrough Reports shows how to create your own reports and associate them to Report Builder reports as customized clickthrough reports.

Tutorials for Reporting Services Development

These tutorials illustrate basic Reporting Services programming features :

Accessing the Report Server Web Service Using Visual Basic or Visual C# shows you how to access the Report Server Web service to retrieve item properties.

Generating RDL Using the .NET Framework uses the XmlTextWriter and sample data to create a report definition programmatically.

Updating Reports Using Classes Generated from the RDL Schema uses the xsd tool to generate C# or VB classes from the RDL schema that let you update report definitions programmatically.

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.

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.