Transcript Introduction to SQL Server 2005 Reporting Services

Introduction to SQL Server
2005 Reporting Services
•Melville Thomson
•IT Pro Evangelist
•http://blogs.technet.com/melville
•[email protected]
Agenda
• Introducing SQL Server 2005
Reporting Services
• Creating and Publishing Reports
• Delivering and Managing Reports
SQL Server 2005 BI
Integrate
Analyze
Data acquisition from
source systems and
integration
Data transformation
and synthesis
Data enrichment with
business logic and
hierarchical views
Data discovery
through data mining
Report
Data presentation
and distribution
Data access for
the masses
What Is Reporting Services?
Browser
Data Sources
(SQL, OLE DB, XML/A,
ODBC, Oracle, Custom)
Custom Application
Office
XML Web Service Interface
Report Server
Security Services
(NT, Passport,
Custom)
Report Processing
Output Formats
(HTML, Excel, PDF, Custom)
Data Processing
Security
Rendering
Delivery
SQL Server Database (Report Catalog)
Delivery Targets
(E-mail, SharePoint, Custom)
Top Reporting Services Customers
•
•
5.1 TB Credit Card DW, Rel Query, OLAP, RS
500+ unique reports, 1500+ users, Office BSM
•
•
Catering planning system used in 2,300 hotels
25% time savings in catering forecast generation
•
•
Used by 13,000 agents in 220 offices
Built portal with Visual Studio .NET, SSAS
•
•
700 restaurants, 30,000 users, 700+ concurrent
OLTP/LOB reporting on inventory and sales data
•
•
Reporting on 1.6 TB of data, 35K+ Tx/Min
325 concurrent connections
•
•
Consumer real estate division
98% reduction in report management time
What’s New in Reporting Services
Core
Product
• Design, processing, interactivity
• Performance, scalability
Integration
• MDX queries, AS/IS data sources
• SharePoint Web parts
Developer
Experience
• Reporting Services built in
• Embed reports in Web/Windows apps
End User
Experience
• Create ad hoc reports: Report Builder
• Design models: Model Designer
Demo
demonstration
Viewing Reports as an End User



Review new Reporting Services features
View the new End User Sort feature
View reports in SharePoint
Agenda
• Introducing SQL Server 2005
Reporting Services
• Creating and Publishing Reports
• Delivering and Managing Reports
The Report Lifecycle, Part 1
Creating
Publishing
Managing
Delivering
Report Builder
ClickOnce
WinForms app
Three templates,
Office paradigms
Business models,
not data structures
Explore, find, and
share data
Report Builder Model Designer
Demo
demonstration
Designing and Publishing
Reports as an End User



Use Report Builder to create a report
Run the report
Add a report filter
Report Builder vs. Report Designer
Report Builder
Report Designer
Targeted at business users
Targeted at IT pros and developers
Ad hoc reports
Managed reports
Auto-generates queries using semantic
Native queries (SQL, OLE DB, XML/A,
layer on top of the source
ODBC, Oracle)
Reports built on templates
Freeform (nested, banded) reports
ClickOnce: easy to deploy and manage
Integrated into Visual Studio (BIDS)
Cannot import Report Designer reports
Can edit Report Builder reports
Demo
demonstration
Designing and Publishing
Reports as a Developer



Create a new Report Server project
Create the report layout
Preview and publish the report
Agenda
• Introducing SQL Server 2005
Reporting Services
• Creating and Publishing Reports
• Delivering and Managing Reports
The Report Lifecycle, Part 2
Creating
“Push Model”
Publishing
Report ServerManaging
“Pull Model”
Delivering
Demo
demonstration
Managing Reports Using SQL
Server Management Studio


Examine report properties
Script changes to reports
Visual Studio Integration
Embed reports with
ReportViewer
Server-based or
local reports
Integrated with
VS data features
Windows or
Web forms apps
Visual Studio Standard Edition
Visual Web Developer 2005 Express with RS add-in
Demo
demonstration
Embedding Reports in a Windows
Forms Application


Design and embed a Server-based report
Design and embed a Local Chart report
Session Summary
• Core enhancements; better integration
• Ad hoc reporting with Report Builder
• Visual Studio support and ReportViewer
What else does TechNet give you?
A range of tools and resources for IT professionals that let you plan,
manage ,deploy
•
FREE TechNet Newsletter”
•
FREE Events and Webcasts
•
FREE quarterly “TechNet” magazine
•
FREE comprehensive technical website
•
FREE TechNet Radio, Security Centre, Learning Paths
and
•
Virtual Labs
TechNet Plus Subscription DVD
To subscribe to the newsletter or just to find out more, please visit
www.microsoft.com/uk/technet
Thank you for attending this TechNet
Event
http://www.microsoft.com/uk/technet
PS (The evaluation form is now sent out electronically with your thank you e-mail. This can take up to 5
working days. Please do feedback as we read all the comments and use them to shape future
event content)