Tutorial: Adding Grouping, Sorting, and Formatting to a Basic Report

SQL Server 2008 Books Online

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This tutorial is designed to help you explore additional features in report design by building upon the basic table report created in the previous tutorial. In this tutorial, you will open the report project, add grouping and sorting to the table, add a new column to the table, add a subtotal, provide some formatting, preview the report, and publish the report to a report server.

Requirements

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

Microsoft SQL Server Reporting Services.

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

SQL Server with the AdventureWorks OLTP database.
Microsoft Internet Explorer 6.0 or later.

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 permissions to retrieve data from the AdventureWorks database and to publish reports to the report server.

This tutorial requires that you have completed the previous tutorial, Creating a Basic Report.

Tasks

Lesson 1: Opening the Tutorial Project

Lesson 2: Adding a Group

Lesson 3: Adding a New Column

Lesson 4: Sorting the Detail Data

Lesson 5: Adding a Subtotal

Lesson 6: Applying Formatting and Style

Lesson 7: Publishing the Updated Report

Note:
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.

Other Resources

Report Samples (Reporting Services)
Installing AdventureWorks Sample Databases and Samples
Tutorial: Adding Parameters to a Basic Tabular Report
Tutorial: Advanced Features Using Parameters
Tutorial: Using XML Data in a Report
Designing and Implementing Reports: Tutorials

Help and Information

Getting SQL Server 2008 Assistance