1 / 14

Module 1: Introduction to SQL Server Reporting Services

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

Download Presentation

Module 1: Introduction to SQL Server Reporting Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Module 1:Introduction 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 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

  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 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

  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 Single server Remote database server Web farm

  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

More Related