Back to Search Results

Pre-Requisites:

Before attending this course, students must have:

• MCDBA (Microsoft Certified Database Administrator) certification or equivalent knowledge.

• Exposure to Visual Studio .NET.

• Exposure to creating reports in Microsoft Access or third party reporting products.

• Experience navigating the Microsoft Windows Server™ environment.

• Experience with Microsoft Windows services

• Starting and stopping services.

• Creating service accounts and permissions.

Training Course Overview/Content:

Module 1: Introduction to Microsoft SQL Server Reporting Services

The information in this module introduces the role Reporting Services plays in an organization’s reporting lifecycle, the key features offered by Reporting Services, and the components that make up the Reporting Services architecture.

Lessons

• Overview of Microsoft SQL Server Reporting Services

• Tour of Reporting Services

• Overview of Reporting Services Architecture


No Lab

After completing this module, students will be able to:

• Describe the scenarios in which Reporting Services can be used. This includes being able to:

• Describe the reporting lifecycle.

• Describe the key features of Reporting Services.

• Describe the process of scheduling a report. This includes being able to:

• Describe the process of report delivery.

• Describe the authoring process.

• Describe the process of managing reports.

• Describe the architecture of Reporting Services. This includes being able to:

• Describe the Reporting Services platform.

• Describe Reporting Services components and software prerequisites.

• Describe single server deployment.

• Describe Web farm deployment.


Module 2: Authoring Basic Reports

In this module, students learn about the fundamentals of report authoring, including how to configure data sources and data sets, create tabular reports, summarize data, and apply basic formatting.

Lessons

• Creating a Basic Table Report

• Formatting Report Pages

• Calculating Values


Lab 2: Designing a Simple Report

• Creating a Basic Table Report

• Formatting Report Pages

• Adding Calculated Values

• Referencing Global Values


After completing this module, students will be able to:

• Create a basic report. This includes being able to:

• Use Report Designer.

• Describe the options for creating a report.

• Describe the purpose of Report Definition Language.

• Access data using a data source and a data set.

• Create a table.

• Create groups.

• Apply basic report formatting. This includes being able to:

• Describe the report page structure.

• Add items to a report.

• Create report headers and footers.

• Use calculated values in a report. This includes being able to:

• Create new fields based on data set fields.

• Create expressions as the value of individual text boxes.

• Use aggregate functions.

• Describe the common aggregate functions.

• Use conditional expressions to create dynamic formatting.


Module 3: Enhancing Basic Reports

This module introduces some techniques for enhancing a basic report using document maps, actions, and data regions. Document maps provide navigation through a contents page, actions provide a mechanism for creating custom actions (jumping from one report to another for example), and data regions allow data to be displayed in formats such as a matrix or a list.

Lessons

• Interactive Navigation

• Displaying Data


Lab 3: Enhancing a Simple Report

• Using Dynamic Visibility

• Using Document Maps

• Initiating Actions

• Using a List Data Region


After completing this module, students will be able to:

• Create interactive navigation using report links. This includes being able to:

• Allow the user to navigate to an appropriate level of detail.

• Create a document map.

• Create links and custom report actions.

• Display data using data regions. This includes being able to:

• Describe the data regions available within the Report Designer.

• Create a table data region.

• Create a chart data region.

• Create a list data region.

• Create a matrix data region.

• Choose data regions for a particular report.

• Create a subreport data region.


Module 4: Manipulating Data Sets

In this module, data sets are covered in greater depth, including the use of alternative data sources and interacting with a data set through parameters. Student will learn how to dynamically modify the da