2030 - Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services
Duration: 2 Days.
Prerequisites:
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
Course Description:
This 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
Objectives:
- Understand the architecture of Microsoft Reporting Services and Office integration
- Author reports using the 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
Lesson 1: Introduction to Microsoft SQL Server Reporting Services
Overview of Microsoft SQL Server Reporting Services
Tour of Reporting Services
Overview of Reporting Services Architecture
Lesson 2: Authoring Basic Reports
Creating a Basic Table Report
Formatting Report Pages
Calculating Values
Lesson 3: Enhancing Basic Reports
Interactive Navigation
Displaying Data
Lesson 4: Manipulating Data Sets
Defining Report Data
Using Parameters and Filters
Using Parameter Lists
Lesson 5: Managing Content
Publishing Content
Executing Reports
Creating Cached Instances
Creating Snapshots and Report History
Creating Report Subscriptions
Lesson 6: Administering Reporting Services
Server Administration