SQL Server Reporting Services - PowerPoint PPT Presentation

1 / 26
About This Presentation
Title:

SQL Server Reporting Services

Description:

Announcements. Survey and raffle. Terminology. RDL: Report Definition Language ... Announcements. New Web site: http://www.ClevelandDotNet.info ... – PowerPoint PPT presentation

Number of Views:137
Avg rating:3.0/5.0
Slides: 27
Provided by: Ber7157
Category:

less

Transcript and Presenter's Notes

Title: SQL Server Reporting Services


1
SQL ServerReporting Services
  • By
  • Sam Nasr
  • March 29, 2005

www.ClevelandDotNet.info
2
Agenda
  • Introduction
  • Reporting Services 2000
  • Examples
  • Reporting Services 2005 (Beta 2)
  • QA
  • Announcements
  • Survey and raffle

3
Terminology
  • RDL Report Definition Language
  • Expression custom code using keywords, ops,
    values, or functions (i.e. field, code).
  • Web Archive self-contained, portable report with
    images (used for offline viewing).

4
Features
  • Report Designer
  • Report Builder (Yukon)
  • Report Manager
  • Integration Services (Formerly DTS)
  • Management Tools
  • Tightly integrated with VS
  • Integrated with BI analysis services (Yukon).

5
RS Architecture
6
Subscription (trigger) Methods
  • When report runs
  • When data changes
  • Scheduled

7
Report Formats
  • XML
  • CSV
  • PDF
  • TIFF
  • Excel
  • Web Archive (MHTML-embedded)

8
Delivery Methods
  • File Server Share
  • E-mail
  • Null Delivery (stored in DB)

9
Installation
  • Components of SQL Server
  • Reporting Services
  • Command line utilities
  • Virtual Directories
  • Reports (C\Program Files\Microsoft SQL
    Server\MSSQL\Reporting Services\ReportManager)
  • ReportServer (C\Program Files\Microsoft SQL
    Server\MSSQL\Reporting Services\ReportServer)
  • Databases
  • ReportServer stores report formats, RDL, etc.
  • ReportServerTempDB stores temporary data used
    in processing the reports.

10
Security Tasks
  • Create linked reports
  • Manage all subscriptions
  • Manage data sources
  • Manage folders
  • Manage individual subscriptions
  • Manage report history
  • Manage reports
  • Manage resources
  • Set security for individual items
  • View data sources
  • View folders
  • View reports
  • View resources

11
Security Roles (Default)
  • Browser May view folders, reports and subscribe
    to reports.
  • Content Manager May manage content in the Report
    Server. This includes folders, reports and
    resources.
  • My Reports May publish reports and linked
    reports manage folders, reports and resources in
    a users My Reports folder.
  • Publisher May publish reports and linked reports
    to the Report Server.

12
Yukon (Beta 2) Installation
13
Yukon (Beta 2) Installation
14
Yukon (Beta 2) Installation
15
Yukon (Beta 2) Installation
16
Yukon (Beta 2) Installation
17
Yukon (Beta 2) Installation

18
Yukon (Beta 2) Installation

19
Yukon (Beta 2) Installation
20
Yukon (Beta 2) Installation
21
Yukon Release Dates
  • Currently Available Beta 2
  • May/June 2005 Beta 3
  • End of 2005 Final Release

22
Additional Info
  • SQL Server 2005 Webcasts http//msdn.microsoft.co
    m/sql/2005/2005Webcasts/default.aspx
  • SQL Server 2005
  • http//www.microsoft.com/sql/2005/
  • SQL Server 2000 Reporting Services
  • http//www.microsoft.com/sql/reporting/

23
Recommended Books
  • Microsoft SQL Server 2000 Reporting Services Step
    by Step by Stacia Misner (22.75)
  • Microsoft Reporting Services in Action by Teo
    Lachev (30.95)
  • Introducing Microsoft SQL Server 2005 for
    Developers by Peter DeBetta (16.95)

24
New Hardware
  • Say goodbye to password hassles.  Now you
    can log on to your computer and your favorite Web
    sites with the touch of your finger, without
    having to remember all those passwordssimply
    place your finger on the receiver whenever a
    password or username is required.  Learn more
    about the Fingerprint Reader.

25
Announcements
  • New Web site http//www.ClevelandDotNet.info
  • New Blog http//ClevelandDotNet.blogspot.com
  • New Career Board http//www.ClevelandDotNet.info/
    Careers.html

26
Upcoming Events
  • April 21 SQL Server SIG meeting
  • Internationalization with SQL Server by Michael
    Kaplan (Microsoft)
  • April 25 C/VB.Net SIG meeting
  • Whidbey Globalization by Michael Kaplan
    (Microsoft)
  • May 12 MSDN
  • http//msevents.microsoft.com
Write a Comment
User Comments (0)
About PowerShow.com