Downloaded 269 times
Uploaded byMicrosoft Private Cloud
SQL Server 2008 R2 - Developing Rich Reporting Solutions Presentation
Developing Rich Reporting Solutions with Microsoft SQL Server 2008 R2 discusses new reporting features in SQL Server 2008 R2 including increased data visualization options, geospatial mapping capabilities, and improved integration with SharePoint. It highlights self-service reporting for business users, enhanced report collaboration, and better cross-browser support. The document also covers embedded business intelligence using the new Visual Studio 2010 Report Viewer controls.
SQL Server 2008 R2 - Developing Rich Reporting Solutions Presentation
- 1. Developing Rich ReportingSolutions with Microsoft SQL Server 2008 R2Stella ChanPrincipal Program Manager Microsoft Corporation
- 2. Increase your productivitywith SQL Server 2008 R2 Reporting Services Creating reports
- 3. Report components andshared data set
- 4.
- 5.
- 6. Managing reports viaself-service
- 7.
- 8.
- 9.
- 10. Better cross browsersupport
- 11. Visual Studio 2010Report Viewer ControlsReporting ChallengesHow Do You Deal With:Data stored in multiple data sourcesLimitations in custom report enginesReport development processesExpensive, 3rd party reporting tools Pervasive delivery of informationScalability and reliable report processingSteep learning curves for new toolsDelivery of contextual business insight
- 12. Typical Report LifeCycleManagementDeliveryAuthoring2007 Sales Embedded ReportingWeb ReportXML
- 13. Authoring ReportsMany typesof visualizations
- 14. Authoring ReportsMany typesof layoutsPivotCustomSubtotalsNon-pivotcolumnsCustomHeadersMulti-PivotStepped or Block groupingNested controls
- 15. Managing ReportsEnterprise ScalePlatform
- 16.
- 17.
- 18. Simplified deployment andhost processes
- 19. Central deployment toSharePoint
- 20.
- 21.
- 22. Central manageability ofreport server content
- 23.
- 24.
- 25. Extensible security modelDeliveringReportsMany rendering targetsXMLSQL Report BuilderMicrosoft ExcelHTMLMicrosoft WordCSVTIFATOMAcrobat PDF
- 26. Delivering ReportsViewing thereportReport ServerReport ManagerSharePoint
- 27. Embedding Report inLOB appWindows Forms and ASP .NET
- 28. What’s new inSQL Server 2008 R2?ManagementDeliveryAuthoring2007 Sales Embedded ReportingWeb ReportXML
- 29. Componentizing ReportsSharing andreusing report partsPublish report items to the catalog for re-use
- 30. Users can mix& mash different report items for their desired views
- 31. Report authors cantreat datasets & report items as building blocks
- 32. Users are notifiedwhen updates are availableShared DatasetsShare queries between reports with new .rsdfile type
- 33. Create in ReportBuilder and BIDS
- 34. Save/deploy to reportserver
- 35. Reports and reportparts can reference shared datasets
- 36.
- 37. Add own filtersand calculations
- 38. Dataset query resultscan be cached
- 39. Faster execution duringdesign or view
- 40. Use for long-runningqueries with non-volatile dataGrab-and-go reporting
- 41.
- 42. Sparklines and DataBarsSparklines
- 43. “Data intense, word-sizedgraphics” – Tufte
- 44. Automatic axis alignment. All charts can have the same data points, regardless of source data
- 45. Convert into fullcharts to support additional small multiple scenarios
- 46.
- 47. Show a singlevalue in a cell.
- 48. Min and Maxare automatically determined, but are configurableSparklinesData Bars
- 49. IndicatorsIcons used todepict the status against a value, goals or a trend
- 50. Report authors cancreate their own sets or choose from several pre-configured sets
- 51. Color, icon andsize can be changed based on data
- 52. Automatic support forcomparing each member of a group against siblings
- 53. Can also beplaced inside gaugesIndicators
- 54.
- 55. Map ScenariosProfitability ofairline routes
- 56. Sales by storelocation
- 57. Product sales byshelf space in a store
- 58. Maps are morethan “maps”!
- 59. Where should Ibuild a new store?
- 60. Use SQL Spatialfunctions to determine how far away your customers are from a potential location.
- 61. Election results bystate
- 62. Maps to facilitatereport navigation/drillKey Map FeaturesMaps contains one or more…
- 63. Point Layers (Cities,Customers)
- 64. Line Layers (Routes,roads)
- 65. Polygon Layers (Countries,States)
- 66. Tile Layers (basedon Bing™ Maps)
- 67. Support ESRI shapefiles and SQL spatial
- 68. Show analytical datausing size and color
- 69.
- 70. Wizard for buildingcommon scenariosMap Components (Example 1)Polygon LayerMap LegendsAnalytical DataBubble w/size RuleColor Rule
- 71. Map Components (Example2)Point LayerSQL Spatial QueryPolygon LayerTile LayerSQL Spatial Query
- 72.
- 73. Misc authoring enhancementsLookupfunctions - “joining” 2 datasets
- 74. Interlaced rows fornested group
- 75. Via read/write reportvariables
- 76. Better page numberingand naming support via new global variables
- 77. Rotating Text 270degrees
- 78. Expression based pagebreaksUsing the Map Visualization Stella ChanPrincipal Program ManagerSQL Server Reporting Servicesdemo
- 79. What’s new inSQL Server 2008 R2?ManagementDeliveryAuthoring2007 Sales Embedded ReportingWeb ReportXML
- 80. Microsoft BI OfferingBUSINESSUSER EXPERIENCEBUSINESS MIDDLE TIER& 2010ReportsDashboards DATA INFRASTRUCTURE & BI PLATFORMReporting Services& 2008 R2Microsoft Confidential
- 81. SSRS Add-In InstallReportServerReport Server in SharePoint ModeReporting Services Add-inSecurity Extension Data ManagementReport management UIReport Viewer web partSharePoint Object ModelSharePoint Object ModelSharePoint Integration ArchitectureWSS or MOSS WFESSRS ProxyReport Server DBSharePoint Config / Content DB
- 82. Preloading caches Cachescan be preloaded ad-hoc or on a schedule
- 83. Available for reportsand shared datasets
- 84. New “cache refreshplan” concept
- 85. Each plan consistsof a description, schedule and one combination of parameter values for which cache entry needs to be generated
- 86. Many cache refreshplans per report or shared datasetProgrammability for SharePoint integrationNew 2010 centralized management web service endpoint for both SharePoint integrated and native mode
- 87. AJAX enabled ReportViewer Web PartWhat’s new in SQL Server 2008 R2?ManagementDeliveryAuthoring2007 Sales Embedded ReportingWeb ReportXML
- 88. Exports report dataas ATOM data feeds
- 89.
- 90. Also used bySQL Server Data Services and SharePoint 2010 lists
- 91. Each leaf dataregion has one or more data feeds
- 92. Clients that consumeATOM feeds (e.g., PowerPivot) can pull data directly from SSRSATOM Renderer
- 93. Rendering enhancementsImproved BrowserCompatibility
- 94. IE6-8, Firefox 3,Safari
- 95.
- 96. Fixed standards moderendering problems
- 97.
- 98. Via Globals!RenderFormat.Name tocontrol visibility of report items for specific renderers
- 99. Naming the Excelworksheet tabsVisual Studio 2010 Report Viewer ControlsASP.NET AJAX and Windows Forms
- 100. Free redistributable runtimecomponentsKey features in Visual Studio 2010 Report Viewer ControlsSQL 2008 based local mode
- 101.
- 102. Support for 2008RDLC (tablix, chart/gauge, rich text)
- 103.
- 104. Viewer contains itsown UpdatePanels
- 105.
- 106. Scroll position ismaintained across interactivity
- 107. No more frames– async/sync mode no longer impacts rendering
- 108. Better browser compatibilityReportDesigner(BIDSor RB 3.0)Report Viewer(Remote Mode)PublishReportDataSourceReport Server (Remote) ModeYour ApplicationReport ServerWeb Services APIReport Processing and RenderingSQL Server Catalog (Metadata)
- 109. ReportDesigner(Visual Studio)DataSourceReport DefinitionReportDataEmbedReportRetrieve DataLocal ModeYour ApplicationReport Viewer(Local Mode)Report Processing
- 110.
- 111. Events for interceptingparameters
- 112. “Write a customtoolbar”
- 113. Printing and printersettings
- 114.
- 115. Most toolbar functionalityis available from the client
- 116. Events and propertiesexpose the state of the viewer (error, report loading, loading completed)
- 117.
- 118. Resizable multi-value parameterdropdowns
- 119. Pop-up loading indicatorVS2010 Report Viewer RequirementsNo SQL 2005 support
- 120. Uses the 2008RPL renderer on the server. HTML and GDI transformations happen in the viewer
- 121.
- 122. .Net 3.5 SP1or 4.0 requiredAJAX viewer programmabilityStella ChanPrincipal Program ManagerSQL Server Reporting Servicesdemo
- 123. SummarySelf service reportingfor information workers
- 124. Report components toenhance collaboration and sharing
- 125.
- 126.
- 127. Report as datasource for PowerPivot
- 128.
- 129. Better cross browsersupport and fluid navigation via AJAX
- 130. Embedded BI: Visual Studio 2010 Report Viewer ControlsLinksVisual Studio 2010 Beta2
- 131. SQL Server 2008R2 CTP3
- 132. ISO Image : http://go.microsoft.com/fwlink/?LinkID=165365&clcid=0x409
- 133. x86 Build: http://go.microsoft.com/fwlink/?LinkID=165367&clcid=0x409
- 134. x64 Build : http://go.microsoft.com/fwlink/?LinkID=165368&clcid=0x409
- 135. IA64 Build: http://go.microsoft.com/fwlink/?LinkID=165369&clcid=0x409
- 136. PowerPivot X86 : http://go.microsoft.com/fwlink/?LinkID=168583&clcid=0x409
- 137. PowerPivot X64 : http://go.microsoft.com/fwlink/?LinkID=168584&clcid=0x409
- 138.
- 139. Release Notes: http://go.microsoft.com/fwlink/?LinkId=155801
- 140.
- 141. Brian Hartman’s Blog©2009 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.