Transcript Report Analyze Integrate Data acquisition from source systems

Introducing Reporting
Services for SQL Server
2005
Agenda
Microsoft® SQL Server™ 2005 Overview
What’s in SQL Server 2005 Reporting
Services
Product Enhancements
Cross-product Integration
Microsoft® Visual Studio® Integration
Ad-Hoc Report Creation
SQL Server 2005 Business
Intelligence
Integrate


Data acquisition
from source
systems and
integration
Data transformation
and synthesis
Analyze


Data enrichment,
with business
logic, hierarchical
views
Data discovery via
data mining
Report


Data presentation
and distribution
Data access for
the masses
What is SQL Server Reporting
Services?
Enterprise reporting platform for both traditional
(paper) and interactive reports
Scalable, manageable and embeddable Web
services infrastructure
Integrated with Microsoft® SharePoint®,
Microsoft® Office applications, Visual Studio,
and other familiar tools
Single platform and tools for all types of
structured data (relational, hierarchical,
multidimensional)
Features By Edition
Reporting Services
SQL Server Reporting Services supports the full
reporting life cycle, including Authoring, Management
and Delivery.
Authoring
Management
Delivery
Core Product Enhancements
Extend features based on feedback from SQL2K version
Tighter Integration
Strengthen end-to-end BI and integration with SharePoint
Developer Focus
Unparalleled integration for the Visual Studio developer
Freely redistributable Microsoft® Windows® and Microsoft®
ASP.NET controls
Empowering End Users
Report Builder enables end-user reporting scenarios
SQL Server 2005
Reporting Services
Rich Client Printing
Direct routing of print
jobs without needing to
export
Small Microsoft®
ActiveX ® control
downloaded via browser
Select page range,
orientation, margins
Preview page output
Server enhancements
for performance
Enhanced Expression Editor
List of available
Microsoft® Visual
Basic® .NET
functions
Inline parameter
information
Statement
completion
Real-time syntax
checking
Multi-Valued Parameters
Report developer can
specify any parameter
is multi-valued
Report processing
constructs SQL or
MDX syntax
Multiple default values
also supported
Value sets can passed
via URL or SOAP API
Interactive Sort
Report author can
add ability for end
user to re-sort data
within data regions
Resorting happens
without re-querying
the database
Support for multicolumn and for nested
/ grouped sort
Custom Report Items
Server controls that
extend report processing
Can be data bound and
leverage expressions,
grouping, sorting, and
filtering
Added to Report Designer
toolbox with custom UI
and properties
Third-party vendors can
provide charts, maps,
gauges, barcodes, etc.
Analysis Services Support
MDX and data
mining query
builders
MDX parameter
support
Member extended
properties
Support for server
aggregates
Management Studio Integration
Single point-ofmanagement for
all SQL Server
components
Superset of
Report Manager
functions
Script generation
from property
dialogs
SharePoint Web Parts
Report Explorer
provides browsing of
server namespace
and subscription
Report Viewer used
to view reports
Parts can be
connected or used
standalone
Works in both
SharePoint Portal
Server and Windows
SharePoint Services
Visual Studio Integration
Report design
completely
integrated with
Visual Studio
language projects
Natural extension
of VS data
functionality
Included in VS Pro
and above
Report Controls
Controls make it easy to
embed reporting
functionality into
applications
Windows Forms (rich
client) and Web Forms
(ASP.NET) control
Local processing mode
(no server) or connected
server mode
Report Builder
A new ad-hoc report design tool for Reporting Services
Targeted at business users who want to find and share
answers to interesting questions
Driven from a business model of the data so users do
not need to understand the underlying data structures
Fully integrated with Reporting Services and delivered
in SQL Server 2005
Complements the Visual Studio Report Designer
Not designed to be a full analytical client, or a
replacement for PivotTables
Report Builder
Report Builder Client
Built on top of familiar Microsoft Office paradigms
(Examples: Microsoft® Excel and PowerPoint®)
Reports built via report templates (table, matrix, chart)
“Click once” WinForms
application deployed
from the Report Server
Users can create
new reports or modify
existing reports
Finished reports can be
published to server
Model Designer
Hosted in Visual
Studio .NET (new
project type)
For editing
models used by
Report Builder
Auto-generation
of models from
data sources
(SQL and AS)
Session Summary
SQL Server 2005 Reporting Services…
Builds on SQL Server 2000 version with core
product enhancements
Increases integration with other SQL Server
components and SharePoint
Improves developer productivity through Visual
Studio integration and report controls
Enables ad-hoc report creation through new Report
Builder client