1 / 28

Advanced SQL Server 2005 Reporting Services

Advanced SQL Server 2005 Reporting Services. Melville Thomson IT Pro Evangelist HTTP://blogs.technet.com/melville. Welcome to this TechNet Event . “Pick your Own Collateral” URL for on-line feedback is in your reminder e-mail No Planned Fire Drills Please turn your Mobile Phones off

melvina
Télécharger la présentation

Advanced SQL Server 2005 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. Advanced SQL Server 2005 Reporting Services Melville Thomson IT Pro Evangelist HTTP://blogs.technet.com/melville

  2. Welcome to this TechNet Event • “Pick your Own Collateral” • URL for on-line feedback is in your reminder e-mail • No Planned Fire Drills • Please turn your Mobile Phones off • To find out about future TechNet events: www.microsoft.com/uk/technetevents

  3. What is TechNet Plus? The Toolkit for IT Professionals • TechNet Plus is an annual subscription • Access to TechNet Knowledge Base • No-limits Evaluation software for Testing • Beta software available immediately • 2 Free Technical Support calls worth £320 • 20% off all further Support Calls • Managed Newsgroups with guaranteed answers in 24hrs • Now available by Download from only £230 / year (excl VAT) For all information on TechNet Plus Subscriptions visit: www.microsoft.com/technet/abouttn/subscriptions

  4. The TechNet Programme A range of tools and resources for IT Professionals • FREE TechNet Newsletter • FREE Events and Webcasts • FREE TechNet BETA Central (www.microsoft.com/uk/betacentral) • FREE Quarterly TechNet Magazine • FREE comprehensive technical website • FREE TechNet Radio, Security Centre, Learning Paths and Virtual Labs • TechNet Plus – Now available for Download! www.microsoft.com/technet

  5. Windows Server System SecurityInfrastructure IT OperationsInfrastructure Applications Infrastructure CollaborationInfrastructure

  6. What Will We Cover? • New Data Sources in SSRS 2005 • Reporting Services Data Extensions • Working with SSAS and SSIS Data • End-User Sort and Parameterization • Schedules and Subscriptions

  7. Helpful Experience • Knowledge of Reporting Services • Familiarity with SSIS and SSAS • Experience with SQL Server

  8. Agenda • Understanding Data Extensions • Using Report Models • Building SSAS-Based Reports • Building Parameterized Reports • Creating Schedules and Subscriptions

  9. SQL Server 2005 BI Integrate Analyze Report Data acquisition from source systems and integration Data transformation and synthesis Data enrichment with business logic and hierarchical views Data discovery through data mining Data presentation and distribution Data access for the masses

  10. Data Sources and Extensions SP1 • SQL Server • OLE DB • ODBC • Oracle • Other .NET Providers • SSIS • SSAS • XML • Report Models • SAP R/3 • SAP BW Data Sources (SQL, OLE DB, ODBC, Oracle, Custom) Data Processing Rendering Output Formats (HTML, Excel, PDF, Custom) ReportServer Report Processing SQL Server Report Catalog

  11. Integrating SSIS and SSRS \MSSQL.n\Reporting Services\ReportServer\rsreportserver.config Install SSIS; uncomment extension entry Design the package properly Set up account for unattended reports

  12. demonstration Demo Creating Reports on Integration Services Packages • View the IS Package in Visual Studio • Design a Report that Consumes the IS Package

  13. Agenda • Understanding Data Extensions • Using Report Models • Building SSAS-Based Reports • Building Parameterized Reports • Creating Schedules and Subscriptions

  14. Report Model Data Extension

  15. demonstration Demo Designing Reports that Use Report Models • Design a Report in Report Builder • Design a Report in Report Designer • Use a Drill-through Report

  16. Agenda • Understanding Data Extensions • Using Report Models • Building SSAS-Based Reports • Building Parameterized Reports • Creating Schedules and Subscriptions

  17. Analysis Services Integration MDX queries DMX queries Analysis Services Data Sources ReportServer Report Processing Data Processing OLAP Cube SQL Server Report Catalog Data Mining Model MDX parameters Member extended properties Server aggregates

  18. demonstration Demo Creating Reports on Analysis Services • Build a Report that Uses a Data Mining Model • Build a Report that Uses a Cube • Add Programmatic Padding and Show/Hide Functionality

  19. Agenda • Understanding Data Extensions • Using Report Models • Building SSAS-Based Reports • Building Parameterized Reports • Creating Schedules and Subscriptions

  20. Parameters in Reports Complete a data query Link reports Filter the query data Populate drop-downs Change report layout

  21. demonstration Demo Adding End-User Sorting and Parameters to Reports • Build a New Report • Enable Detail-Level Sorting • Enable Group-Level Sorting

  22. Agenda • Understanding Data Extensions • Using Report Models • Building SSAS-Based Reports • Building Parameterized Reports • Creating Schedules and Subscriptions

  23. Schedules • Management events Caching, subscriptions, history • Stored in database Integrated with SQL Agent • Polled by Windows service • Calls the Report Processor Shared schedules

  24. Subscriptions • Event-triggered • Delivery extension specifies delivery type • Specify parameters and format • Deliver links and rendered reports http://

  25. Subscription Types Standard Data-Driven Single report to one or more addresses Subscribe with User!UserID and User!Language Dynamic destination list Customized content for each destination

  26. Session Summary • New data sources, especially SSIS and SSAS • End-user sort and parameterization • Subscriptions automate report deliveries

  27. Ihr Potenzial. Unser Antrieb. Thank you for attending this TechNet Event Find these slides at: http://www.microsoft.com/uk/technetslides

  28. Melville Thomson IT Pro Evangelist http://blogs.technet.com/melville

More Related