United States   Change   |   All Microsoft Sites

Home

Reporting Services

SQL Server 2008 Reporting Services

Overview

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.

Top New Features

  • “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

Report Builder 3.0

Click image to enlarge

Author

Create comprehensive, richly formatted reports quickly and easily.

Use a comprehensive report design environment

  • 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

Create reports from a wide range of data sources

  • 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 report authoring for business users

  • 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

Choose from flexible data representation options

  • 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™

Visualize data

  • 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

Report Builder Management Tools

Manage

Ease management of your reporting environment with a variety of powerful manageability tools.

Use comprehensive management 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

Secure your reporting solution

  • 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

Customize management operations

  • Use the extensible architecture and open interfaces to integrate reporting solutions in diverse IT environments

Reporting Services Configuration Manager

Reporting Services Configuration Manager

Deliver

Deliver richly formatted reports to users through a variety of mechanisms.

Achieve high-performance report processing

  • 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

Render reports to a wide range of formats

  • 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

Deliver reports automatically through subscriptions

  • 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

Embed reports into applications and portals

  • 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

Additional Resources

 

Join the Conversation!

           

Community Center

SQL Server Events

Forums and Blogs

Take the next step

Report Definition Language

Download the Essential Backpack
TechNet IT Pros Start Here
MSDN Developers Start Here
The Future of Productivity is Here