140 likes | 335 Vues
Module 1: Introduction to SQL Server Reporting Services. Overview. Overview of SQL Server Reporting Services Installing Reporting Services Reporting Services Tools. Lesson 1 : Overview of SQL Server Reporting Services. The Reporting Lifecycle Highlights of Reporting Services
E N D
Overview • Overview of SQL Server Reporting Services • Installing Reporting Services • Reporting Services Tools
Lesson 1 : Overview of SQL Server Reporting Services • The Reporting Lifecycle • Highlights of Reporting Services • Reporting Services Scenarios
The Reporting Lifecycle DELIVERY MANAGEMENT AUTHORING RDL Any .NET managed data provider Report Designer, Report Builder or custom • Runtime report rendering • Pull • Report Manager • Custom • Push • E-mails • Custom Central Report Server database Managed report execution Secured reports Web-based Report Manager or custom
Reporting Services Scenarios Internal Reporting External Reporting Embedded Reporting
Lesson 2: Installing Reporting Services • Reporting Services Architecture • Reporting Services Installation • Installation Scenarios
Reporting Services Architecture Browser Microsoft Office Custom Applications Web UI Programmatic Interfaces Report Server Report Processing Report Sources Security Data Processing Security Services Delivery Rendering Delivery Channels Output Formats Report Server Database
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)
Installation Scenarios Single server Remote database server Web farm
Lesson 3: Reporting Services Tools • Reporting Services Developer Tools • Reporting Services Management Tools
Lab: Using Reporting Services Tools • Exercise 1: Exploring Report Designer • Exercise 2: Exploring Report Manager