Creating Reporting Solutions

This course provides attendees with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services.

After completing this course, students will be able to:

• Understand the Architecture of Microsoft Reporting Services and Office integration
• Author reports using Report Designer
• Deploy and publish reports
• Manage the lifecycle of a report, including report scheduling and backup and restore
• Understand how to apply Reporting Services to a business problem

Course Times	9am-5pm
Who should attend	Database Administrators Database Developers IT Professionals
Pre Requisites	MCDBA certification or equivalent Exposure to Visual Studio .NET Exposure to creating reports in MS Access or third party reporting Experience navigating the Microsoft Windows Server environment

Agenda

Day 1

Topic	Description
Lesson 1: Introduction to Microsoft SQL Server Reporting Services	Overview of Microsoft SQL Server Reporting Services Tour of Reporting Services as an end user Overview of Reporting Services Architecture System requirements Competitors to Reporting Services
Lesson 2: Authoring Basic Reports	Creating a Basic Table Report Formatting Report Pages Calculating Values
Lesson 3: Enhancing Basic Reports	Interactive Navigation Displaying Data with expressions
Lesson 4: Manipulating Data Sets	Defining Report Data Using Parameters and Filters Using Parameter Lists

Day 2

Topic	Description
Lesson 5	Publishing Content Executing Reports Creating Cached Instances Creating Snapshots and Report History Creating Report Subscriptions
Lesson 6	Server Administration Performance and Reliability Monitoring Database Administration Security Administration
Lesson 7	Querying Server Information Automating Report Management Rendering Reports Creating Custom Code
Lesson 8	Introduction to Performance Point
Lesson 9	Best Practices for Reporting Services

Acknowledgements

Adam Cogan