Tutorials: Creating AdventureWorks 2008R2 Sample Reports (SSRS)

The suite of AdventureWorks sample reports provide examples of reports, report design, and report features for SQL Server Reporting Services. These sample reports are available as a Report Server project in a Business Intelligence Development Studio solution. For more information, see Reporting Services Samples.

There are two report authoring environments in which you can create reports for Reporting Services.

  • Report Designer in Business Intelligence Development Studio provides a Visual Studio user interface that is familiar to developers. In a BI Development Studio solution file, you can create multiple Report Server projects. By using projects and folders, you can organize multiple shared data sources, shared datasets, reports, and resources. You can deploy individual items or all items to a report server, including report parts. You cannot add an item from the report server directly to a report or report project.

  • Report Builder 3.0 is a stand-alone application that has an Office Ribbon user interface. In Report Builder, you open one report or one shared dataset at a time. If you have sufficient permissions, you can open and change reports or shared datasets directly from a report server.

    Note

    The AdventureWorks 2008R2 sample reports are not designed to run in Report Builder 3.0. If you are a beginning report writer, you can learn about report design concepts and features from Report Builder topics, tutorials, samples, and videos. For more information, see Getting Started with Report Builder 3.0 and Tutorials (Report Builder 3.0) in the Report Builder 3.0 documentation on msdn.microsoft.com; and Report Builder 3.0 sample reports.

The tutorials in this section help an experienced report writer build the AdventureWorks 2008R2 sample reports by using Report Designer in Business Intelligence Development Studio. This set of reports provides examples for the current set of report design features for SQL Server 2008 R2 Reporting Services. Because of the complexity of nested report items in some of the reports, it is recommended that you review report design tips in Report Design Tips (Report Builder 3.0 and SSRS).

Requirements

For the list of requirements, see Prerequisites for AdventureWorks 2008R2 Sample Reports (SSRS).

Tasks

The following table describes the suite of AdventureWorks 2008R2 sample reports and their relationships.

Report Title

Purpose

Relationships

Tutorial

AdventureWorks2008R2_Base

Covers tasks that are common to each report: page header and footer contents, scenario text placeholder and the toggle to display it, description text placeholder, parameters and parameter display, and the shared data source.

Includes examples for setting conditional visibility both by toggle and by expression based on a boolean parameter.

The base report for each tutorial. The tutorial for each report begins by making a copy of this base report and renaming it.

Creating the Report Server Project and the AdventureWorks2008R2_Base Report (SSRS)

Employee_Sales_Summary_2008R2

Displays sales for one month in comparison to the same sales for previous years.

Displays current sales compared to quotas.

Contains a drillthrough action on the sales order number in a matrix that opens Sales_Order_Detail_2008R2.

Creating the Employee_Sales_Summary_2008R2 Report (SSRS)

Sales_Order_Detail_2008R2

Displays sales order details for a range of sales order numbers.

Uses Store_Contacts_2008R2 as a subreport in the sales order header area.

Creating the Sales_Order_Detail_2008R2 Report (SSRS)

Store_Contacts_2008R2

Displays contact information for a store.

Used as a subreport in Sales_Order_Detail_2008R2.

Creating the Store_Contacts_2008R2 Report (SSRS)

Sales_by_Region_2008R2

Displays locations of AdventureWorks reseller stores and individual customers in the United States.

Contains a drillthrough action on the store marker in the map and the store field in the matrix that opens Customers_Near_Stores_2008R2.

Creating the Sales_by_Region_2008R2 Report (SSRS)

Customers_Near_Stores_2008R2

Displays individual customers who live near an AdventureWorks reseller store.

Used as a target report for a drillthrough action in Sales_by_Region_2008R2.

Creating the Customers_Near_Stores_2008R2 Report (SSRS)

Change History

Updated content

  • Changed report include AdventureWorks2008R2_Base.rdl