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