COURSE 9185 | 2-DAY SESSION
SQL Server 2005 Reporting Services

---

Course Outline

I. Introduction to Reporting Services

• Overview of Reporting Services
  
• The Role of Reporting Services
  
• Key Features of Reporting Services
  
• Configuring a Reporting Services Architecture
  

Lab 1

• Discussing the need of reporting services
  
• Designing the reporting services architecture
  

II. Installing and Initial Configuration of Reporting Services

• Installing Reporting Services
  
  • Installation Requirements
    
  • Installation Scenarios
    
• Exploring the Reporting Services Tools
  
  • Developer Tools
    
  • Management Tools
    

Lab 2

• Installing Reporting Services
  
• Working with the Report Designer
  
• Working with Report Manager
  
• Exploring the other Tools
  
  

III. Authoring Reports

• Basics of Report Authoring
  
  • Configuring Data Sources
    
  • Creating Tabular Reports
    
  • Summarizing Data
    
  • Applying Basic Formatting
    
• Enhanced Reports
  
  • Navigation controls
    
  • Interactive Navigation
    
  • Displaying Data
    

Lab 3

• Creating a Basic Table Report
  
• Formatting the Report
  
• Adding Calculated Values
  
• Working with Document Maps
  
• Using Dynamic Visibility
  
• Creating Actions
  
• Using a List Data Region
  

IV. Working With Data Sets

• Defining Report Data
  
  • Connecting to a Data Source
    
  • Querying a Data Source
    
• Use of Alternate Data Sources
  
• Interacting with a Data Set using Parameters
  
  • Using Parameter Filters
    
  • Using Parameter Lists
    
• Best Practices for using Static and Dynamic Parameter Lists
  
• Defining Report Data
  

Lab 4

• Restricting Query Results
  
• Filtering Report Data
  
• Dynamic Parameter Lists
  
• Parameters with Stored procedures
  
• Displaying all Categories in a parameter list
  

V. Report models

• Understanding When to Use Report Models
  
  • Working with Users
    
• Creating a Report Model
  
  • Report Model Objects and Concepts
    
  • Report Model Options
    
  • Working with Model Designer
    
• Working with Report Builder
  
  • Defining Report Builder
    
  • Working with folders and Entities
    
  • Sorting and Grouping Data
    
  • Filtering Data
    
  • Viewing a Report
    

Lab 5

• Creating a Report Model
  
• Creating Different Reports
  
• Using Report Builder to Create a Report
  

VI. Executing and Publishing Reports

• Executing Reports
  
  • Process Flow
    
  • Reports on Demand
    
  • Session Caching
    
  • Linked Reports
    
• Publishing Reports
  
  • Publish With Report Designer
    
  • Publish With Report Manager
    
  • Updating Data Sources, Reports, and Report Properties
    
• Cached instances
  
  • Executing
    
  • Using Query Parameters
    
  • Using Filters with Cached Instances
    
• Snapshots and Report History
  
  • Executing Snapshot Reports
    
  • Using Query Parameters
    
  • Using Filters
    
  • Configuring Snapshots
    
  • Using Report History
    
  • Configuring Report History
    

Lab 6

• Publishing Reports
  
• Executing Reports
  
• Creating a Cached Instance
  
• Using a Snapshot and Report History
  

VII. Report Services Subscriptions

• Defining Report Subscriptions
  
  • Subscriptions Scenarios
    
• Creating Report Subscriptions
  
  • Standard Subscriptions
    
  • Data-Driven Subscriptions
    
• Managing Report Subscriptions
  
  • Using Report Manager
    
  • Controlling Report Distribution
    
  • Subscription and Delivery Availability
    
  • Monitoring Availability
    

Lab 7

• Creating a Subscription Scenario
  
• Using a Data Driven Subscription
  
• Working with a Standard Subscription
  

VIII. Reporting Services Management

• Server Administration
  
  • Configuration Files
    
  • Configuration Manager
    
  • Service Accounts
    
• Security
  
  • Authorization Model
    
  • Assigning Roles
    
  • Securing Items
    
  • System Level Role Definitions
    
  • Secure the System
    
• Performance
  
  • Trace Files
    
  • Logging Report Execution
    
  • Performance Counters
    
  • Timeouts
    
  • Suspending Jobs
    
• Administrating Databases
  
  • Database Storage
    
  • Backup and Restore Strategy
    

Lab 8

• Using the Reporting Services Manager
  
• Securing the Reporting Server and Site
  
• Securing Items