![Page 1: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/1.jpg)
SQL Server 2005 Reporting Services
Hamsa Gayatri Palepu
![Page 2: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/2.jpg)
• SQL Server 2005 Reporting Services is a key
component of SQL Server 2005. • Reporting Services was first released with
SQL Server 2000 and provided customers with an enterprise-capable reporting platform with a comprehensive environment for authoring, managing, and delivering reports to the entire organization.
Introduction
![Page 3: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/3.jpg)
• Reporting Services in SQL Server 2005 provides additional enterprise reporting capabilities and addresses a new audience—business users who want to interact with data in an ad hoc fashion as well as create their own reports from scratch and to share them with others.
• In Reporting Services, the requirements of different types of users who want to interact with reports can, for the first time, be addressed with one reporting solution. This document describes the new capabilities in SQL Server 2005 Reporting Services.
![Page 4: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/4.jpg)
What is SQL Server Reporting What is SQL Server Reporting Services?Services?
• Reporting platform for both traditional and Reporting platform for both traditional and interactive reports interactive reports
• Scalable and manageable server Scalable and manageable server infrastructureinfrastructure
• Integrated with SharePoint, Office Integrated with SharePoint, Office applications, browser and other familiar applications, browser and other familiar tools tools
• Single platform and tools for all types of Single platform and tools for all types of structured data (relational, hierarchical, structured data (relational, hierarchical, multidimensional)multidimensional)
![Page 5: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/5.jpg)
SQL Server CatalogSQL Server Catalog
Report ServerReport Server
URL / XML Web Service InterfaceURL / XML Web Service Interface
Report ProcessingReport Processing
DeliveryDelivery
Delivery Targets(E-mail, File Share,
Custom)
RenderingRendering
Output Formats (HTML, Excel, PDF, Custom)
Data ProcessingData Processing
Data Sources(SQL, OLE DB, XML/A, ODBC, Oracle, Custom)
SecuritySecurity
Security Services(Windows,
Custom)
Office Custom ApplicationBrowser
Report Server Architecture
![Page 6: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/6.jpg)
Introducing SQL Server 2005 Packaging
.
ExpressExpress WorkgroupWorkgroup StandardStandard EnterpriseEnterpriseFastest way for
developers to learn, build & deploy simple
data driven applications
Easiest to use & most affordable database solution for smaller
departments & growing businesses
Complete data management &
analysis platform for medium businesses
and large departments
Fully integrated data management and
analysis platform for business critical
enterprise applications
2 CPU2 CPU
3 GB RAM3 GB RAM
Management Management StudioStudio
Import/ExportImport/Export
Limited Replication Limited Replication PublishingPublishing
Back-up Log-Back-up Log-shippingshipping
4 CPU4 CPU
Unlimited RAMUnlimited RAM(64-bit)(64-bit)
Database MirroringDatabase Mirroring
OLAP ServerOLAP Server
Reporting ServerReporting Server
New Integration New Integration ServicesServices
Data MiningData Mining
Full Replication & Full Replication & SSB PublishingSSB Publishing
Unlimited Scale Unlimited Scale + Partitioning+ Partitioning
Adv. DB mirroring, Adv. DB mirroring, Complete online & Complete online &
parallel operations, parallel operations,
DB snapshotDB snapshot
Advanced Analysis Advanced Analysis Tools including full Tools including full
OLAP & Data OLAP & Data MiningMining
Report Builder + Report Builder + Customized & High Customized & High
Scale ReportingScale Reporting
Adv SSISAdv SSIS
1 CPU1 CPU1 GB RAM1 GB RAM
4GB DB Size4GB DB Size
Simple Simple Management ToolManagement Tool
Report Wizard & Report Wizard & Report ControlsReport Controls
Replication & Replication & SSB ClientSSB Client
![Page 7: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/7.jpg)
SQL Server BI PlatformSQL Server BI Platform
Analysis ServicesAnalysis ServicesOLAP & Data MiningOLAP & Data Mining
IntegrationIntegrationServicesServices
ETLETL
SQL ServerSQL ServerRelational EngineRelational Engine
Reporting ServicesReporting ServicesM
anag
emen
t To
ols
Man
agem
ent T
oo
lsD
evel
op
men
t T
oo
lsD
evel
op
men
t T
oo
ls
![Page 8: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/8.jpg)
AuthoringAuthoring ManagementManagement DeliveryDelivery
Reporting Lifecycle
SQL Server Reporting Services supports the full SQL Server Reporting Services supports the full reporting lifecycle, including Authoring, reporting lifecycle, including Authoring, Management and DeliveryManagement and Delivery
![Page 9: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/9.jpg)
Report ManagementReport Management Report definitions, folders, and resources are published
and managed in a reporting web service Managed reports can be executed either on-demand or
via schedule and can be cached for consistency and performance
Scalable & Extensible server architecture
![Page 10: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/10.jpg)
Report DeliveryReport Delivery Traditional (paper) and interactive (web) reports On-demand (“pull”) or event-based (“push”) delivery
Personalized and administrator defined subscription and deliveryAbility to select output formats per subscriptionCan deliver links as well as rendered reportsData-driven subscriptions for personal delivery
Single report definition can be rendered to diverse output formatsWeb Formats (HTML 4, HTML 3.2, HTML w/OWC)Print Formats (TIFF, RTF, PDF)Data Formats (Excel, XML, CSV)
Deliver reports to many devices (e-mail, file share, etc.)
![Page 11: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/11.jpg)
![Page 12: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/12.jpg)
![Page 13: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/13.jpg)
![Page 14: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/14.jpg)
![Page 15: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/15.jpg)
![Page 16: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/16.jpg)
![Page 17: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/17.jpg)
![Page 18: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/18.jpg)
![Page 19: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/19.jpg)
![Page 20: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/20.jpg)
![Page 21: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/21.jpg)
![Page 22: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/22.jpg)
![Page 23: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/23.jpg)
![Page 24: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/24.jpg)
![Page 25: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/25.jpg)
![Page 26: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/26.jpg)
![Page 27: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/27.jpg)
![Page 28: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/28.jpg)
![Page 29: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/29.jpg)
![Page 30: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/30.jpg)
![Page 31: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/31.jpg)
![Page 32: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/32.jpg)
Rich Client PrintingRich Client Printing
• Direct routing of print Direct routing of print jobs without needing to jobs without needing to exportexport
• Small ActiveX control Small ActiveX control downloaded via downloaded via browserbrowser
• Select page range, Select page range, orientation, marginsorientation, margins
• Preview page outputPreview page output• Server enhancements Server enhancements
for performancefor performance
![Page 33: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/33.jpg)
Enhanced Expression Editor
• Available for all expressions in VS Report Designer
• List of available VB.NET functions
• Inline parameter information
• Statement completion
• Real-time syntax checking
![Page 34: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/34.jpg)
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
![Page 35: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/35.jpg)
Date Picker Parameters
• Calendar control for choosing dates
• Localized and Globalized
• Windows and Web support
![Page 36: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/36.jpg)
Interactive Sort
• Report author can add ability for end user to resort data within data regions
• Resorting happens without re-querying the database
• Support for multi column and for nested / grouped sort
![Page 37: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/37.jpg)
Floating Headers
• New type of interactivity similar to freeze panes in Excel
• Works Horizontally and Vertically• Table header• Matrix column and row headers• Table columns
• Must be continuous columns anchored on the right or left
![Page 38: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/38.jpg)
MDX Query Builder
• MDX and data mining query builders
• MDX parameter support
• Member extended properties
• Support for server aggregates
![Page 39: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/39.jpg)
Custom Report Item
• Enables Developers to add custom visualizations to a report• Primary scenario is enhanced charting
– Additional chart types– Maps– Gauges
• Supports interactivity– Actions– Sort
• Supports all data region features– Filter– Grouping– Group Filters– Etc…
• The Report Designer supports a conversion API
• Currently limited to images– Future plans for all report item types
![Page 40: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/40.jpg)
Advantages
• Increased Productivity
• Integrated End-to-End Feature Set
• Delivering BI with Fewer Resources
• Reliable and Available Environment for Critical BI
![Page 41: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/41.jpg)
ResourcesResources• http://www.microsoft.com/technet/http://www.microsoft.com/technet/
prodtechnol/sql/2005/2005ssrs.mspxprodtechnol/sql/2005/2005ssrs.mspx
• http://www.microsoft.com/sqlserver/2005/en/us/white-papers.aspx
• http://download.microsoft.com/download/a/4/7/a47b7b0e-976d-4f49-b15d-f02ade638ebe/bi_business_value.pdf
• Pubs and NorthWind Pubs and NorthWind http://go.microsoft.com/fwlink/?LinkId=30196 http://go.microsoft.com/fwlink/?LinkId=30196
![Page 42: SQL Server 2005 Reporting Services Hamsa Gayatri Palepu](https://reader035.vdocuments.us/reader035/viewer/2022062321/56649da65503460f94a9132f/html5/thumbnails/42.jpg)
END