Introducing Microsoft SQL Server 2000 Reporting Services Brian

Introducing Microsoft SQL Server 2000 Reporting Services Brian Welcker Group Program Manager SQL Server Reporting Services Microsoft Corporation

Reporting Services Vision Enable employees at all levels of an organization to realize the promise of BI to promote better decision making Delivered through l Traditional and interactive reports l Scalable, manageable and embeddable server infrastructure l Integration with Share. Point, Office applications, browser and other familiar tools l Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)

Scenarios l Enterprise Reporting Ø In-house reports (Sales, Finance, HR) § l Embedded Reporting Ø Report processing included in applications § l Manageability, portal and LOB integration Extensible, embeddable architecture B 2 B Reporting Ø Partner reporting via extranets, Internet § Data isolation, extensible security

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

Reporting Lifecycle SQL Server Reporting Services supports the full reporting lifecycle, including Authoring, Management and Delivery Authoring Management Delivery

Report Authoring Report developers can create reports to be published to the Report Server using Microsoft or 3 rd party design tools that support the Reporting Services XML Report Definition Language (RDL) Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

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 Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

Report Delivery Reporting Services supports both on-demand (“pull”) and event-based (“push”) delivery of reports; Users can view reports from a web-based front-end or subscribe for reports to be delivered in e-mail Authoring Management Delivery Online Access Report Definition Managed Report Delivery Channels

Reporting Services

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

Key Differentiators l Full Reporting Platform Ø Ø Ø l All server components are extensible Completely embeddable Published, extensible report definition Scalability and Performance Ø Ø Designed from day one to be a. NET web service Web farm architecture Optimized processing and rendering Reports execute as CLR assemblies

Next Steps l Download Reporting Services Evaluation Edition (after January 27 th) Ø l Sign up for Launch Web Cast Ø l http: //mssql. digisle. tv/ For more information, please email Ø l http: //www. microsoft. com/sql/reporting SCDLITE@microsoft. com You can download event presentations at Ø http: //www. microsoft. com/usa/southcentral/

Hitachi Consulting’s Solution Offerings Eric Winton Manager Technology Solutions Hitachi Consulting

Mary Kay Inc.

Mary Kay Situation l l l l Data resides on different servers Disjointed reporting system High data volumes Real-time and scheduled batch needed Single point of access Support for multiple platforms Low, cost all-encompassing reporting solutions

Mary Kay Reporting Solution l Standard Development Architecure Ø Ø l Report Portal Application Ø Ø Ø l Stored Procedures Reporting Services Access for all reports Parameter Entry Role Based Security Framework Architecture Ø Ø ASP. NET Platform Configuration Database

Mary Kay Benefits l l Reduced costs Improved business insight Ability to leverage existing investments Easy on-going maintenance

RDL Generator 2. 0 l l l Converts Crystal Report to RDL Open RDL output and modify in Visual Studio. NET Features Ø Ø l Easily extensible Ø Ø l Header, Footer, Formatting Groupings, SQL Query String 95% Conversion Goal Other Reporting Formats Saves time and money!

RDL Generator 2. 0

Call To Action Hitachi Consulting will work with you to enable your business to leverage the benefits of a Reporting Servicesbased solution, quickly! Hitachi Booth Register to win Windows Mobile Smart Phone For more information, please email ewinton@hitachiconsulting. com You can download all presentations at www. microsoft. com/usa/southcentral/

SQL Server Summit Brought To You By: