Welcome to this evening’s TechNet Event

1. Welcome to this evening’s TechNet Event We would like to bring your attention to the key elements of the TechNet programme; the central information and community resource for IT professionals in the UK: • FREE bi-weekly technical newsletter • FREE regular technical events hosted across the UK • FREE weekly UK & US led technical webcasts • FREE comprehensive technical web site • Monthly CD / DVD subscription with the latest technical tools & resources • FREE quarterly technical magazine To subscribe to the newsletter or just to find out more, please visit www.microsoft.com/uk/technet or speak to a Microsoft representative during the break

2. Microsoft SQL Server 2000 Reporting Services Melville Thomson Parity Training

3. What we will cover: • Architecture • Creating reports • Importing reports • Publishing reports • Viewing reports • Subscriptions

4. Prerequisite Knowledge • Experience administering SQL Server • Experience administering IIS • Experience generating database reports • Familiarity with Visual Studio.NET Level 300

5. Agenda • Architecture and Deployment • Creating Reports • Managing Reports

6. What is SQL Server Reporting Services? • Reporting platform for both traditional and interactive reports • Scalable, manageable and embeddable server infrastructure • Integrated with SharePoint, Office applications, browser and other familiar tools • Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)

7. SQL Server BI Platform Reporting Services Development Tools Management Tools Analysis Services OLAP & Data Mining Data Transformation Services ETL SQL Server Relational Engine

8. Microsoft BI Product Suite MBS BI Applications Excel OWC Map Point Data Analyzer OLAP addin BSCA SharePoint Portal Server Dev Tools Visual Studio .Net Reporting Services Management Tools Analysis Services OLAP & Data Mining Data Transformation Services SQL Server Relational Engine Windows Server

9. SQL Server Analysis Services SQL Server Reporting Services Reporting ServicesBI User Profiles Analysts 5-10% of users Information Explorers 15-25% of users Information Consumers 65-80% of users

10. Authoring Management Delivery Reporting Lifecycle Reporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.

11. Report Authoring • Reports are defined in Report Definition Language (RDL), a documented XML schema • Use Microsoft or 3rd party tools that support RDL • Create single reports from multiple data sources(SQL, OLE DB, ODBC, Oracle, and .NET data providers) More info on the RDL spec: www.microsoft.com/sql/reporting

12. Report Management • Report definitions, folders, and resources are published and managed in a reporting web service • Managed reports can be executed either on-demand or via schedule and are cached for consistency and performance • Scalable & Extensible server architecture

13. Report Delivery • Traditional (paper) and interactive (web) reports • On-demand (“pull”) or event-based (“push”) delivery • Choose from multiple formats (HTML, Excel, PDF, XML) • Deliver reports to almost any device (e-mail, file share, etc.)

14. Browser Management Custom App Data Sources (SQL, OLE DB, ODBC, Oracle, Custom) Output Formats (HTML, Excel, PDF, Custom) URL WMI Web Service Report Server Report Processing Rendering Data Retrieval Security Delivery SQL Server Catalog Delivery Targets (E-mail, File share, Custom) Architecture and DeploymentReporting Services

15. Connection Management Tool Third-Party Tools Report Designer Browser Report Manager Report Server Request Handler Rendering Extensions Scheduling and Delivery Processing Data Processing Extensions Report Processor Delivery Extensions Data Source Report Server DB Architecture and DeploymentArchitecture and Components

16. Data Report Definition Intermediate Format On-demand Access Scheduled or Push Access Rendered page in HTML, PDF or other format Layout Snapshot or Report History Architecture and DeploymentReport Processing

17. Architecture and DeploymentReporting Services Client Components • Report Designer • Integrated with Visual Studio.NET 2003 • Web Browser • View and Manage Reports • Third Party Tools • Management • Authoring • Supported through URL, WMI or Web Services API

18. Server Client Report Manager Report Server Report Designer Report Server Database Architecture and DeploymentSmall Deployment

19. Server A Server B Client Report Manager Report Server Report Designer Report Server Database Architecture and DeploymentMedium Deployment

20. Report Server Web Farm Clients Report Server Report Server Report Server Data Sources SQL Server Cluster Report Server Database Report Server Database Architecture and DeploymentLarge Deployment

21. Agenda • Architecture and Deployment • Creating Reports • Managing Reports

22. Creating ReportsVisual Studio .NET Integration

23. Creating ReportsReport Definition Language (RDL) • Report Definition Language – XML schema contains • Data source information • Layout • Report Properties • Definitions stored in Report Server Database • Can create tools that use RDL

24. Creating ReportsReport Creation Process • Connect to the data source • SQL Server, Analysis Services, Oracle, ODBC and OLE DB • Specify the query • Arrange the report items on the page • Page header, page footer and body • Preview the results • Publish the report

25. Report Items • Textbox • Image • Line • Rectangle • Subreport • Data Regions (List, Table, Matrix, Chart) • Custom Report Items coming in SQL Server 2005! $100,000

26. All Report Items Background Color Background Image Border Color Border Style Border Width Padding Charts Background Gradient Textboxes Color Font Family Font Size Font Style Font Weight Format Line Height Text Align Text Decoration Vertical Align Item Styles

27. Repeating regions with freeform layout Similar to “bands” in other report writers But multiple lists can sit side-by-side! Lists inside lists to get multiple levels of grouping Use for complex repeating areas Lists Brian $10,000 Jason $20,000 Steve $30,000

28. Like lists with columns Fixed columns, repeating rows Table cells can span columns Table cells can contain any report item Easier to align items Use for most reports Tables Person Region Sales Brian North $10,000 Dan North $20,000 Total North $30,000 Steve East $50,000 Total East $50,000 Grand Total $80,000

29. Repeats in row and column directions Also known as pivot table or cross tab Arbitrary formatting in headers Different formatting for subtotals Matrix cells can contain any report item Use when column headings are records in your data Matrices Sales 2000 2001 2002 Brian $100 $110 $120 Jason $200 $250 $300 Steve $300 $400 $300 Total $600 $760 $720

30. Data from fields in the data set or from expressions Full set of chart properties and types Style enhancementsin SP1 Same data functionality as Matrix Charts

31. Creating ReportsPreviewing and Publishing Reports • Debug – Preview • View reports in local preview window • Production – Publish • Publish reports to a production report server

32. demonstration Creating Reports

33. Welcome Back to this evening’s TechNet Event We would like to bring your attention to the key elements of the TechNet programme; the central information and community resource for IT professionals in the UK: • FREE bi-weekly technical newsletter • FREE regular technical events hosted across the UK • FREE weekly UK & US led technical webcasts • FREE comprehensive technical web site • Monthly CD / DVD subscription with the latest technical tools & resources • FREE quarterly technical magazine To subscribe to the newsletter or just to find out more, please visit www.microsoft.com/uk/technet or speak to a Microsoft representative during the break

34. Agenda • Architecture and Deployment • Creating Reports • Managing Reports

35. Managing ReportsReport Manager • View, Search and Subscribe to Reports • Create and manage: • Folders • Linked reports • Report history • Schedules • Data source connections • Subscriptions • Set properties and report parameters • Manage role definitions and assignments

36. Managing ReportsReport Manager

37. Managing ReportsViewing Reports • Reports can be rendered in: • HTML • HTML with Office Web Components • XML • CSV • Excel • Image – such as TIFF • Acrobat PDF file

38. Managing ReportsReport Subscriptions

39. Managing ReportsReport Execution Processing • On Demand • On Demand From Cache • Removed from cache at defined intervals • From Snapshots • Query is separate from render

40. Managing ReportsSecuring the Report Server and Reports • Reporting Server Security • Uses IIS security • Windows security • User Permissions • Windows security • Role-based authorization

41. URL Parameter Directives • Syntax • http://server/virtualroot? /reportpath &prefix:param • Report Server Parameters (rs:) http://localhost/reportserver?/SampleReports&rs:Command=ListChildren http://localhost/reportserver?/SampleReports/Employee+Sales+Summary&rs:Command=Render&EmpID=26 http://localhost/reportserver?/SampleReports/Product+Line+Sales&rs:Format=Excel&rs:Command=Render • Rendering Device Info (rc:) • Name/Values pairs specifying information about the format being rendered to (i.e., FindString, Section, Zoom, etc.) • Example find 7th page: http://localhost/ReportServer?/SampleReports/Product+Catalog&rc:Section=7&rc:HTMLFragment=true

42. demonstration Managing Reports

43. Reporting Services Summary • Supports the full reporting life cycle • Highly scalable • You do not need to know RDL to create a report definition • Supports several data sources • Reports can be rendered in a variety of formats • Reports can be executed on demand or cached for quicker access

44. For More Information… • Microsoft SQL 2000 Reporting Services www.microsoft.com/sql/reporting • Reporting Services Tech Overview www.microsoft.com/sql/reporting/techinfo • Main TechNet Web site at www.microsoft.com/technet

45. Developer Productivity • .NET Framework hosting • Native XML technology • Integrated web services • Distributed application framework Business Intelligence • Comprehensive ETL platform • Real time analytics • Accessible, easy data mining • Rich, integrated reporting Enterprise Data Management • Flexible, manageable, scalable • Improved serviceability • Self optimization and tuning • Fast recovery and restore Secure, Quality Database • 3 years in development • Multiple security reviews • Secure by default • Large private beta for early quality

46. MS PressInside information for IT Professionals To find the latest titles, visit www.microsoft.com/learning/books/

47. 3rd Party PublicationsSupplementary publications for IT Pros These books can be found and purchased at all major book stores and online retailers

48. Microsoft LearningTraining Resources for IT Professionals • Creating Reporting Solutions using Microsoft SQL Server 2000 Reporting Services • Course Number: 2030 • Available Now • Detailed Syllabus: www.microsoft.com/learning To locate a training provider, please accesswww.microsoft.com/learning

49. Assess your ReadinessMicrosoft Skills Assessment What is Microsoft Skills Assessment? • Self-study learning tool to evaluate readiness for product and technology solutions, instead of job-roles (certification) • Windows Server 2003, Exchange Server 2003, Windows Storage Server 2003, Visual Studio .NET, Office 2003 • Free, online, unproctored, and available to anyone • Answers the question: “Am I ready?” • Determines skills gaps and provides learning plans with Microsoft Official Curriculum courses • Post your High Score to see how you stack up • visitwww.microsoft.com/assessment

50. Become a Microsoft Certified Systems Administrator (MCSA) • What is the MCSA certification? • For IT professionals who manage and maintain networks and systems based on Microsoft Windows Server • How do I become an MCSA on Microsoft Windows Server 2003? • Pass 3 core exams • Pass 1 elective exam or 2 CompTIA certifications • Where do I get more information? www.microsoft.com/mcsa