United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
Microsoft SQL Server 2008 R2 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.
“Grab and Go” reporting experience enabled through the Report Part Gallery
Support for maps and geospatial visualizations with integration to Bing maps and support for SQL spatial data types
Additional visualizations including indicators, sparklines and data bars
Support for consuming SharePoint lists and PowerPivot models as data sources
Support for Madison and SQL Azure data sources
Render any report as a data source to PowerPivot or other applications through ATOM data feeds
Report Builder 3.0
Click image to enlarge
Create comprehensive, richly formatted reports quickly and easily.
Benefit from increased productivity through familiar Microsoft Visual Studio-based report development tools. Take advantage of intuitive design interfaces and wizards to quickly build reporting solutions
Build reports from different data sources throughout your enterprise. Data sources can be from SQL Server, Oracle, DB2, SQL Azure, PowerPoint Workbooks, SAP NetWeaver BI, Hyperion Essbase, and others.
Enable business users to create their own reports and explore corporate data by using Microsoft Report Builder 3.0, an intuitive and familiar Microsoft Office-optimized authoring environment
Report Builder 3.0 enables users to re-use existing report components from a shared library, empowering them to build reports without deep technical understanding of the underlying data structures
Build semantic report models from SQL Server Relational and Analysis Services databases, and from Oracle databases to support end-user reporting
Format reports in the way that makes most sense for your particular reporting needs
Use a tabular format for fixed data reports and Matrix format for dynamic crosstab reports; or combine the two formats by using the new highly innovative data representation format of TABLIX™
Enrich reports by visualizing data graphically, leveraging a wealth of new rich mapping, gauge and charting capabilities
Take advantage of additional chart enhancements including annotations, custom color palettes, scale breaks, merged charts, and multiple axes
Report Builder Management Tools
Ease management of your reporting environment with a variety of powerful manageability tools.
Schedule report execution, manage report subscriptions, and control access to reports through the Web-based Report Manager
Integrate Reporting Services with Microsoft SharePoint Technologies for central manageability of reports in a familiar Office environment
Deploy and manage all of your Reporting Services configuration options by using Reporting Services Configuration Manager
Use the Reporting Services role-based security model to secure access to reports, folders, resources and shared data sources
Grant access to users by assigning them to built-in and custom role definitions
Use the extensible architecture and open interfaces to integrate reporting solutions in diverse IT environments
Reporting Services Configuration Manager
Deliver richly formatted reports to users through a variety of mechanisms.
Deliver reports more efficiently with the re-engineered report engine
Limit memory usage and conflicts with non-memory bound reports
Optimize report performance with on-demand processing and instance-based rendering
Reach users across the organization with reports rendered in the format that makes the most sense for them
Rendering options offer a variety of formats including HTML, PDF, CSV, XML, and Image (TIFF) as well as Microsoft Office Word and Excel
Use subscriptions to deliver reports at a specific time and/or location
Deliver reports through e-mail or post them to a shared folder on your network
Enable business users to subscribe to reports, or create data-driven subscriptions to centrally manage automatic multi-recipient report delivery
Use the Microsoft Report Viewer controls in Visual Studio to embed reports directly into your business applications or leverage the Report Viewer Web Server control to host reports in ASP.NET projects
Publish reports to a Microsoft Office SharePoint report library or embed reports directly into portals by using the Reporting Services Report Viewer Web Part for renderings within SharePoint
Community Center
SQL Server Events
Forums and Blogs
Reporting Services
