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