CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

MS2030 - Creating Reporting Solutions using MS SQL Server 2000

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This two-day course provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Students should leave the course with a good understanding of how to apply reporting services to problems within a business context.

Click here for a printer-friendly version of this page

Prerequisites

Before attending this course, students should have exposure to Visual Studio .NET., exposure to creating reports in Microsoft Access or third party reporting products, experience navigating the Microsoft Windows Server environment and experience with Microsoft Windows services including starting and stopping services and creating service accounts and permissions.

Detailed Class Syllabus

Module 1: Introduction to Microsoft SQL Server Reporting Services

Overview of Microsoft SQL Server Reporting Services

Tour of Reporting Services

Overview of Reporting Services Architecture

Module 2: Authoring Basic Reports

Creating a Basic Table Report

Formatting Report Pages

Calculating Values

Module 3: Enhancing Basic Reports

Interactive Navigation

Displaying Data

Module 4: Manipulating Data Sets

Defining Report Data

Using Parameters and Filters

Using Parameter Lists

Module 5: Managing Content

Publishing Content

Executing Reports

Creating Cached Instances

Creating Snapshots and Report History

Creating Report Subscriptions

Module 6: Administering Reporting Services

Server Administration

Performance and Reliability Monitoring

Database Administration

Security Administration

Module 7: Programming Reporting Services

Querying Server Information

Automating Report Management

Rendering Reports

Creating Custom Code