Module 1 Introduction to SQL Server Reporting Services

Module 1: Introduction to SQL Server Reporting Services

Overview of SQL Server Reporting Services Installing Reporting Services Tools

Lesson 1 : Overview of SQL Server Reporting Services The Reporting Lifecycle Highlights of Reporting Services Scenarios

The Reporting Lifecycle AUTHORING RDL Any. NET managed data provider Report Designer, Report Builder or custom MANAGEMENT DELIVERY Central Report Server database Runtime report rendering Managed report execution Pull Secured reports Web-based Report Manager or custom Report Manager Custom Push E-mails Custom

Highlights of Reporting Services Lifecycle Stage Highlight Wide range of supported data sources Authoring Open report authoring options Flexible report designs Parameterized reports Manageme nt Delivery Execution properties Report scheduling and history Role-based security Range of rendering options Flexible and extensible delivery

Reporting Services Scenarios Internal Reporting External Reporting Embedded Reporting

Lesson 2: Installing Reporting Services Architecture Reporting Services Installation Scenarios

Reporting Services Architecture Microsoft Office Browser Custom Applications Web UI Programmatic Interfaces Report Server Report Processing Report Sources Data Processing Security Services Output Formats Rendering Delivery Channels 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 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

Reporting Services Developer Tools Tool Purpose Report Designer Design, preview, and publish reports from within Visual Studio environment Model Designer Define, edit, and publish report models that are used in Report Builder Allows information workers to design, test, and publish reports using a report model Report Builder

Reporting Services Management Tools Tool Purpose Report Manager View and manage reports using a Web browser Reporting Services Configuration Tool Provides a graphical interface for configuring a report server Rsconfig. exe manages a report server connection to the report server database Command Prompt Utilities Rskeymgmt. exe manages encryption keys used by the report server Rs. exe runs scripts that perform automated management features

Lab: Using Reporting Services Tools Exercise 1: Report Designer Exploring Exercise 2: Report Manager Exploring