Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services Training in Boulder Colorado

Training Program Details

Program Outline

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 data set underlying a data region allowing parameters to be sent to the underlying query. This module presents various best practices for dealing with static and dynamic parameter lists when interacting with stored procedures.

Lessons

Defining Report Data

Using Parameters and Filters

Using Parameter Lists

Lab 4: Manipulating Data Sets

Using Parameters to Restrict Query Results

Using Parameters to Filter Report Data

Creating Dynamic Parameter Lists

Using Parameters with a Stored Procedure

Displaying All Categories in a Parameter List

Simulating a Multi-select Parameter List

After completing this module students will be able to:

Describe the features of a data set. This includes being able to:

Connect to a data source.

Query a data source using a data set.

Use parameters to restrict query results. This includes being able to:

Describe why report parameters are used.

Use report parameters.

Use query parameters.

Describe the use of filters.

Create a data filter.

Use parameter lists with a report. This includes being able to:

Pass parameters to a stored procedure.

Create a dynamic parameter list.

Allow the user to display all items in a data set.

Simulate the effect of a multi-select parameter list.

Module 5: Managing Content

This module introduces the management of content in the Reporting Services database. The module discusses the process of deploying reports together with the various mechanisms that can be used in deployment. Students learn about the report execution models supported by Reporting Services including the caching of report instances. Finally students learn about using subscriptions for report delivery.

Lessons

Publishing Content

Executing Reports

Creating Cached Instances

Creating Snapshots and Report History

Creating Report Subscriptions

Lab 5: Managing Content

Publishing Reports

Executing Reports

Creating Subscriptions

After completing this module students will be able to:

Publish content to the Report Server. This includes being able to:

Publish a report using the Report Designer.

Publish a report using Report Manager.

Update a data source.

Update a report.

Configure report properties.

Execute reports on-demand. This includes being able to:

Describe the process of report execution.

Describe how a report on-demand is executed.

Describe how session caching works.

Create a linked report.

Created cached instances of reports. This includes being able to:

Describe the processing steps when executing a cached report.

Describe the use of query parameters on a cached instance.

Describe the use of filters on a cached instance.

Configure a cached instance of a report.

Create snapshot reports and report history. This includes being able to:

Describe how a snapshot report is executed.

Use query parameters on a snapshot report.

Use filters on a snapshot report.

Configure a snapshot report.

Describe the purpose of report history.

Configure report history.

Deliver reports using subscriptions. This includes being able to:

Describe the purpose of subscriptions.

Create a standard subscription.

Create a data-driven subscription.

Module 6: Administering Reporting Services

This module introduces the administration of the Reporting Services server the administration of individual jobs and the administration of the database. In this module students will learn how to administer the Reporting Services server monitor and optimize the performance of the Report Server maintain the Reporting Services databases and keep the system secure.

Lessons

Server Administration

Performance and Reliability Monitoring

Database Administration

Security Administration

Lab 6: Administering Reporting Services

Deploying the Demonstration Reports

Securing the Site

Securing Items

After completing this module students will be able to:

Use configuration files to administer the Report Server. This includes being able to:

Describe the Report Server configuration files.

Assign security accounts for the Report Server.

Monitor the performance and reliability of the Report Server. This includes being able to:

Describe the purpose of the Report Server trace files.

Configure the level of tracing.

View report execution log information.

Utilize Report Server performance counters.

Apply timeouts to long-running queries or reports.

Suspend jobs.

Administer the ReportServer and ReportServerTempDB databases. This includes being able to:

Describe how Report Server stores information.

Estimate required disk space for a Report Server installation.

Define a backup and restore strategy.

Administer the Reporting Services security model. This includes being able to:

Describe the Report Server authorization model.

Assign roles.

Modify and create item-level roles.

Secure individual items using roles.

Modify and create system-level roles.

Secure the Report Server site.

Module 7: Programming Reporting Services

This module introduces the programmatic control of Reporting Services. In this module students will learn how to query Reporting Services information programmatically and how to automate their report management tasks. They will also learn how to render reports without relying on Report Manager and how to create custom code to extend the feature set of the Report Server.

Lessons

Querying Server Information

Automating Report Management

Rendering Reports

Creating Custom Code

Lab 7: Programming Reporting Services

Viewing Report Server Management Information

Managing a New Report Using the Report Server Web Service

After completing this module students will be able to:

Retrieve information about the server. This includes being able to:

Describe Web services.

Describe what information is available using the Report Server Web service.

Retrieve server information using the Report Server Web service.

Automate report management tasks. This includes being able to:

Describe report management automation.

Automate tasks using Web services.

Automate tasks using scripting.

Render reports programmatically. This includes being able to:

Render reports from a Web page.

Render reports programmatically using the Report Server Web service.

Create custom code and call the custom functionality from reports. This includes being able to:

Describe Reporting Services extensions.

Describe the uses for custom assemblies.

Related Exams

No Microsoft Certified Professional exams are associated with this course currently.

Student 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.

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services

Training Provided by American IT

Training Avaliability and Delivery

Training Program Details

Program Outline

Related Exams

Student Pre-Requisites

Student Materials

Program Goals

About American IT - Training Provider

More Training from American IT