Creating Reporting Solutions Using Microsoft SQL Server 2000 Reporting Services

Students will leave the course with a good understanding of how to apply Microsoft SQL Server 2000 Reporting Services to problems within a business context and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

This course is intended for all types of reporting users including server and content managers, designers, and developers who are responsible for the design and administration of report solutions. Days 1 and 2 focus on Reporting content, while Day 3 offers a more in depth view of Reporting Services Administration.

Download Course
Overview

An Introduction to Reporting Services - Controlling Page Layouts

• Fundamentals of Reporting - Formatting Report Pages
• Introduction to Reporting Services - Using Calculated Values
• Navigation within Reporting Services - Adding Interactive Capabilities to Reports
• The Reporting Services Architecture - Report Design Considerations
• Using Document Maps

Report Authoring

• Introduction to the Visual Studio .Net Report Designer
• Creating Table Based Reports

Managing Content

• Initiating Actions
• Alternative Data Regions - Content Management Overview
• Publishing Content

Managing Data Sets - Report Execution Options

• Parameters and Filters - Report Delivery Options
• Creative Datasets
• OLAP as a Dataset

Administering Security Programming Reporting Services

• Security Fundamentals - Supporting User Access
• Item Security - Report Rendering Options
• System Security - Automated Report Management
• Data Security - Reporting Services Advanced
• Programmability

Administering Reporting Services

• Components
• Server Administration
• Job Administration
• Database Administration