Module 1: Introduction to SQL Server Reporting Services

1
Module 1Introduction to SQL Server Reporting
Services
2
Overview

• Overview of SQL Server Reporting Services
• Installing Reporting Services
• Reporting Services Tools

3
Lesson 1 Overview of SQL Server Reporting
Services

• The Reporting Lifecycle
• Highlights of Reporting Services
• Reporting Services Scenarios

4
The Reporting Lifecycle
DELIVERY
MANAGEMENT
AUTHORING

• Runtime report rendering
• Pull
• Report Manager
• Custom
• Push
• E-mails
• Custom

• RDL
• Any .NET managed data provider
• Report Designer, Report Builder or custom

• Central Report Server database
• Managed report execution
• Secured reports
• Web-based Report Manager or custom

5
Highlights of Reporting Services
6
Reporting Services Scenarios
Internal Reporting
External Reporting
Embedded Reporting
7
Lesson 2 Installing Reporting Services

• Reporting Services Architecture
• Reporting Services Installation
• Installation Scenarios

8
Reporting Services Architecture
Microsoft Office
Custom Applications
Browser
Web UI
Programmatic Interfaces
Report Server
Report Processing
Report Sources
Data Processing
Security
Security Services
Rendering
Delivery
Delivery Channels
Output Formats
Report Server Database
9
Reporting Services Installation

• Installed through SQL Server Setup
• Multiple instances supported
• Server requirements
• Microsoft Internet Information Services 5 or
  later
• .NET Framework 2.0
• Access to an SMTP Server (for e-mail delivery)
• Report Server database requirements
• SQL Server 2005
• SQL Server 2005 Express
• Client requirements
• Browser for viewing/managing reports
• .NET Framework 2.0 (for Report Builder or BIDS)

10
Installation Scenarios
11
Lesson 3 Reporting Services Tools

• Reporting Services Developer Tools
• Reporting Services Management Tools

12
Reporting Services Developer Tools
13
Reporting Services Management Tools
14
Lab Using Reporting Services Tools

• Exercise 1 Exploring Report Designer
• Exercise 2 Exploring Report Manager