1 / 19

Report Management and Creation using Microsoft SQL Server 2008 Reporting Services

Learn to create and manage compelling reports with SQL Server 2008 Reporting Services. Explore new features like Tablix data region and enhanced visualizations for better report authoring and delivery.

julier
Download Presentation

Report Management and Creation using Microsoft SQL Server 2008 Reporting Services

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Report Management and Creation using Microsoft SQL Server 2008 Reporting Services Chris Testa-O’Neill Database Product Planner Remarc Group

  2. The next 60 minutes Report Authoring Services Reporting Integration Analysis Synch Entity Data Model Report Management Query Search FILE RDBMS OLAP XML Report Delivery Mobile and Desktop Server Cloud Report Server Installation “Combing thenew and established features to create and manage compelling reports”

  3. Agenda Summary Report Authoring Report Authoring • New Report Designer • New Tablix data region • Enhanced Visualisation through gauges and charts Report Management Report Delivery • New and Improved rendering options • Standard and Data Driven Subscriptions Report Delivery Report Server Installation Report Server Installation • Streamlined installation options • IIS agnostic • SharePoint Integration Report Management • Report Manager Administration • Report Server Configuration

  4. Report Authoring:Key Features • Enable users to create powerful reports • Build powerful reports • Create reports with any structure using Tablix • Add rich text regions your reports • Embed powerful graphical data visualizations into reports . • Increase the flexibility of your reports • An Enhanced Report Builder empowers users to create their own reports • Parameters and Filters create dynamic reports

  5. Report Authoring:New Data Regions • Innovative Tablix Data Region • Combines the benefits of both a table and matrix data region • Not explicitly found in any of the report authoring tools • Flexible Reporting Structures • Combining Fixed and Dynamic data provides tidier reports • Parallel Dynamic Grouping of data within a single data region • You can optional omit row and column headings in table like structures

  6. Report Authoring:Visualisation and ad-hoc reporting • Visualisation to impart Crucial Information Efficiently • Chart Properties provide more control over the presentation of Charts • Scale breaks provide for better readability • Secondary Axis introduced • Gauges embedded to a cell level • Empower your users to create their own reports • Still requires that a report model is created • Enhancements include

  7. Agenda Summary Report Authoring • New Report Designer • New Tablix data region • Enhanced Visualisation through gauges and charts Report Delivery • New and Improved rendering options • Standard and Data Driven Subscriptions Report Server Installation. • Streamlined installation options • IIS agnostic • SharePoint Integration Report Management • Report Manager Administration • Report Server Configuration

  8. Report Delivery:Rendering Reports • Microsoft Office Word • New Microsoft Word rendering format. • Improved Excel Rendering • Rendering Architecture changes to the benefit of Microsoft Office Excel.

  9. Report DeliverySubscribing to Reports • Standard Subscriptions • Delivers one report to one destination • Designed for users and administrator use. • Delivery using email or fileshare • Data Driven Subscriptions • Delivers many reports to many destinations. • Administrator use only • Requires the creation of a “Subscription” Table

  10. Demo: Creating and Delivering Reports

  11. Agenda Summary Report Authoring • New Report Designer • New Tablix data region • Enhanced Visualisation through gauges and charts Report Delivery • New and Improved rendering options • Standard and Data Driven Subscriptions Report Server Installation • Streamlined installation options • IIS agnostic • SharePoint Integration Report Management • Report Manager Administration • Report Server Configuration

  12. Report Management:Report Manager Administration • Report Manager Administration • General page to move, delete and create linked reports • Parameters page to set parameter properties • Execution page can be used to improve report performance with Snapshots and Cache settings • History page configures read only, point in time snapshot of data • Security page to control authorisationagainst the report

  13. Report Management Reporting Server Configuration • Report Server Configuration Manager • IIS agnostic • Single service account configuration • SharePoint Integration • Report Server administration • Better control over memory • Redesigned Report Engine • ReportServer and ReportServerTempDB

  14. Demo: Administering Reports and ConfiguringReporting Services

  15. Agenda Summary Report Authoring • New Report Designer • New Tablix data region • Enhanced Visualisation through gauges and charts Report Delivery • New and Improved rendering options • Standard and Data Driven Subscriptions Report Server Installation • Streamlined installation options • IIS agnostic • SharePoint Integration Report Management • Report Manager Administration • Report Server Configuration

  16. Report Server Installation:Streamlined Installation • Improved and Easier Installation Experience • Installation allows SSRS 2008 to run immediately after installation. • IIS dependency removed • Single Service account configuration • SharePoint Integration now part of the installation • Issues with side by side deployment during migration. Should install SSRS 2008 in Files installation mode. Use Configuration manager to customise the installation.

  17. Summary Report Authoring • New Report Designer • New Tablix data region • Enhanced Visualisation through gauges and charts Report Delivery • New and Improved rendering options • Standard and Data Driven Subscriptions Report Server Installation • Streamlined installation options • IIS agnostic • SharePoint Integration Report Management • Report Manager Administration • Report Server Configuration

  18. Required slide: Please customize this slide with the resources relevant to your session Microsoft Resources • Microsoft E-learning Clinic: 6258. IT’S FREE!http://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=89922 • SQL Server 2008 Marketing Pagehttp://www.microsoft.com/sqlserver/2008/en/us/default.aspx • Microsoft Learning and Certificationhttp://www.microsoft.com/learning/sql/2008/default.mspxhttp://www.microsoft.com/learning/mcp/sql/2008/default.mspx • Microsoft Developer Network (MSDN) & MSDN Magazinehttp://microsoft.com/msdn http://msdn.microsoft.com/magazine • Trial Software and Virtual Labshttp://www.microsoft.com/technet/downloads/trials/default.mspx learn support connect subscribe MSDN Library Knowledge Base Forums MSDN Magazine User Groups Newsgroups E-learning Product Evaluations Videos Webcasts V-labs Blogs MVPs Certification Chats

  19. Required slide: Please customize this slide with the resources relevant to your session Additional Resources • Microsoft Learning and Certificationhttp://www.microsot.com/learning/sql/2008/default.mspx • SQLServerFAQhttp://www.sqlserverfaq.com/ • LearnSQLServer.org – Released November 2008http://www.LearnSQLServer.org • Remarc Groupwww.remarc.co.uk/remarcgroup/bitsoffer.aspx • Chris Testa-O’Neill co’neill@remarc.co.uk

More Related