SQL Server 2005 Reporting Services

1
SQL Server 2005 Reporting Services

• SommarKollo Microsoft

2
Agenda

• Introducing Reporting Services
• Reporting Services Component Overview
• Creating Reports
• Deploying Reports
• Browsing Reports
• Administering Reports
• Conclusion

3
Introducing Reporting Services

• Business Intelligence Component
• Rich set of tools
• Graphic Environment
• A lot for free
• A lot Auto Magic
• Versatile Report Design
• Server-based reporting platform
• Report Server
• Windows Service
• Web Service
• Database Storage

4
Reporting Services Component Overview

• Managed Environment
• Report Server
• Windows Service
• Initialization
• Scheduling
• delivery
• Web Service
• Programmatic Access
• Data Sources
• Relational
• Multi Dimensional
• Procession Extensions
• Rendering Extensions
• Report Manager

5
Creating Reports

• Report Designer
• Developer Driven
• Visual Studio Shell
• Infrastructure layout
• Report Wizard, use without shame
• Manual development, could be time-consuming
• Report Builder
• End User Driven
• Developer Initiated
• Ad Hoc for users
• RDL
• XML based language

6
Deploying Reports

• Standard
• Single Instance of Report Server
• Local or remote database
• Scale Out
• High availability
• Performance
• Single report database

Load Balanced
High Availability
7
Browsing Reports

• Rendring Extensions
• XML
• CSV
• Image (TIFF)
• PDF
• Excel
• HTML
• OWC
• NULL (Cache)

• Web
• URL Access Parameters
• Report Manager
• Rendering Extensions
• Mail File Share Custom
• Printing
• Subscriptions

OR
Intermediate Format like Cache, Snapshots or Repor
t History
On Demand
Data
Report Definition Queries Expressions CodeReferen
ces
Rendered Reportby aRendering Extension
Schema or Push
Layout
8
Tools for Administering Reports

• SQL Server Configuration Manager
• SQL Server Surface Area Configuration
• SQL Server Management Studio
• Report Manager
• Reporting Services Configuration Tool
• Reporting Services Command Line Utilities

9
What to Administer

• Relational databases
• Metadata object definitions
• Security
• Role-based Windows authentication or Custom
• Report Execution
• Automating Reports
• Encrypted values
• Web Service
• Windows Service
• Logs
• Performance

10
Conclusion

• Several data sources
• Several report formats
• Flexible authoring
• Rendering extensions
• Server based
• Centrally managed
• Managed environment