Introducing the new features in microsoft sql server 2008 r2 reporting services
Download
1 / 22

Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services - PowerPoint PPT Presentation


  • 376 Views
  • Uploaded on

Required Slide. SESSION CODE: BIE308. Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services . Peter Myers Mentor Solid Quality Mentors. Presenter Introduction. Mentor, Solid Quality Mentors BBus, MCITP (Dev, DBA, BI), MCT, MVP

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Introducing the New Features in Microsoft SQL Server 2008 R2 Reporting Services' - hertz


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Introducing the new features in microsoft sql server 2008 r2 reporting services

Required Slide

SESSION CODE: BIE308

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

Peter Myers

Mentor

Solid Quality Mentors


Presenter introduction
Presenter Introduction

  • Mentor, Solid Quality Mentors

  • BBus, MCITP (Dev, DBA, BI), MCT, MVP

  • 13 years’ experience designing and developing software solutions using Microsoft products

  • [email protected]


Session agenda
Session Agenda

  • Introducing New Report Design Features

  • Introducing New Developer Features

  • Introducing New Administrator Features


Introducing new report design features
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


Sharepoint list graphic query designer
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


Layout features
Layout Features

  • Pagination control:

    • Disabled

    • ResetPageNumber

    • PageName

  • Data Alignment

  • Text Box orientation: Rotate270


Expression language
Expression Language

  • Lookup functions:

    • Lookup

    • MultiLookup

    • LookupSet

  • Aggregate of aggregates

  • Built-in functions:

    • OverallPageNumber

    • OverallTotalPages

    • RenderFormat.Name

    • RenderFormat.IsInteractive

  • Read/write report variables


Data visualizations
Data Visualizations

  • Map

  • Data Bar

  • Sparkline

  • Indicator


Shared components
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


Atom data feeds
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


Report builder 3 0
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


Introducing new developer features
Introducing New Developer Features

  • Reporting Services Web Services

  • ReportViewer Control


Reporting services web services
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


Reportviewer control
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


Introducing new administrator features
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


Introducing the new features in microsoft sql server 2008 r2 reporting services1

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

Peter Myers

Mentor

Solid Quality Mentors

DEMO


Related content

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


Resources

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


Required Slide

Complete an evaluation on CommNet and enter to win!


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


© 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.



ad