Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services

1. Required Slide SESSION CODE: BIE308 Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services Peter Myers Mentor Solid Quality Mentors

2. Presenter Introduction • Mentor, Solid Quality Mentors • BBus, MCITP (Dev, DBA, BI), MCT, MVP • 13 years’ experience designing and developing software solutions using Microsoft products • pmyers@solidq.com

3. Session Agenda • Introducing New Report Design Features • Introducing New Developer Features • Introducing New Administrator Features

4. Introducing New Report Design Features • SharePoint List Graphic Query Designer • Layout Features • Expression Language • Data Visualizations • Shared Components • ATOM Data Feeds • SharePoint Lists • Report Builder 3.0

5. SharePoint List Graphic Query Designer • Supports retrieving data from SharePoint Server lists • WSS 3.0, and greater • MOSS 2007 • Office SharePoint Server 2010 • Available in both Report Designer and Report Builder 3.0 • To configure: • Set the site URL • Select the list and required columns • Define filters • Lists with folders are not supported

6. Layout Features • Pagination control: • Disabled • ResetPageNumber • PageName • Data Alignment • Text Box orientation: Rotate270

7. Expression Language • Lookup functions: • Lookup • MultiLookup • LookupSet • Aggregate of aggregates • Built-in functions: • OverallPageNumber • OverallTotalPages • RenderFormat.Name • RenderFormat.IsInteractive • Read/write report variables

8. Data Visualizations • Map • Data Bar • Sparkline • Indicator

9. Shared Components • Shared dataset • Publish and reuse datasets • Report parts (“grab and go reporting”) • Publish, consume and customize data regions, parameters and images • Designed for consumption using Report Builder 3.0’s Report Gallery

10. ATOM Data Feeds • Data regions can be rendered as ATOM data feeds • Each data region can deliver a data feed • Useful for importing report data into PowerPivot and other integration scenarios

11. Report Builder 3.0 • Next generation report authoring tool • Replaces Report Builder 2.0 • Includes new data visualizations • Allows creating and using shared datasets • The Report Gallery allows users to search for, and introduce, published report parts • Supports relative references for reports, subreports and images • Supports the new graphic designer for creating data sources based on SharePoint Lists • Improved performance with edit sessions

12. Introducing New Developer Features • Reporting Services Web Services • ReportViewer Control

13. Reporting Services Web Services • New management endpoint: ReportService2010 • Consolidates classes for native and integrated mode • Deprecates the ReportService2005 and ReportService2006 endpoints • ReportExecution2005 endpoint is still used to execute reports

14. ReportViewer Control • The Visual Studio 2010 ReportViewer Control delivers the Reporting Services 2008 design features • Developers can: • Customize with JavaScript API • Update content internally using ASP.NET AJAX • Use the AJAX UpdatePanel • Better browser support: • IE 6, IE 7, IE 8, Firefox 3.5, and Safari 4.0

15. Introducing New Administrator Features • Cache refresh • Replaces need for NULL delivery provider to warm cache • Updates dataset in cache to help reports run faster • SharePoint Integration • Supports alternate access mappings with Reporting Services • Allows use of RS Utility • Displays Reporting Services calls in the SharePoint Unified Logging Service • RDL sandboxing • Isolates access to report server • Supports hosted services environment

16. Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services Peter Myers Mentor Solid Quality Mentors DEMO

17. Required Slide Speakers, please list the Breakout Sessions, Interactive Sessions, Labs and Demo Stations that are related to your session. Related Content • BIO202 | Building Effective Data Visualizations and Maps with Microsoft SQL Server 2008 Reporting Services • BIU08-INT | Using Microsoft SQL Server 2008 R2 Report Builder 3.0 • BIE01-HOL | Developing and Consuming Report Libraries in Microsoft SQL Server 2008 R2 Reporting Services • BIE02-HOL | Visualizing Data with Maps in Microsoft SQL Server 2008 R2 Reporting Services • BIE03-HOL | Working with ATOM Data Feeds in Microsoft SQL Server 2008 R2 Reporting Services

18. Required Slide Resources Learning • Sessions On-Demand & Community • Microsoft Certification & Training Resources www.microsoft.com/teched www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet • http://microsoft.com/msdn

19. Required Slide Complete an evaluation on CommNet and enter to win!

20. Sign up for Tech·Ed 2011 and save $500 starting June 8 – June 31st http://northamerica.msteched.com/registration You can also register at the North America 2011 kiosk located at registrationJoin us in Atlanta next year

21. © 2010 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

22. Required Slide