SQL Server 2008 Reporting Service

Features in Repoting Service

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