sql server 2005 reporting services: product overview niran luckcanakul (mcsd, mcdba, mct) project...

SQL Server 2005 SQL Server 2005 Reporting Services: Reporting Services: Product OverviewProduct Overview

Niran LuckcanakulNiran Luckcanakul(MCSD, MCDBA, MCT)(MCSD, MCDBA, MCT)Project managerProject managerISONET Co.,LtdISONET Co.,Ltd

AgendaAgenda

Introduction to Reporting ServicesIntroduction to Reporting Services

New Features in Reporting ServicesNew Features in Reporting Services

Ad-Hoc Reporting with report builderAd-Hoc Reporting with report builder

Introduction to Reporting ServicesIntroduction to Reporting Services

SQL Server 2005Reporting ServicesRelational Database

Engine

.NET CLR

Analysis Services

Native HTTP Support

Service BrokerReplication

Full-Text Search

Notification Services

SQL Server Integration Services

AuthoringAuthoring ManagementManagement DeliveryDelivery

Reporting ServicesReporting ServicesReporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.

Web services

Benefits of Reporting ServicesBenefits of Reporting Services

Improving performance for report Improving performance for report development processdevelopment process

Completed server platform for developersCompleted server platform for developers

Advantages of Web-Enabled ReportingAdvantages of Web-Enabled Reporting

Enabled real-time and interactive reportsEnabled real-time and interactive reports

Open, Extensible Enterprise Reporting Open, Extensible Enterprise Reporting PlatformPlatform

Integration with Microsoft Business Integration with Microsoft Business Intelligent ProductsIntelligent Products

Report AuthoringReport AuthoringReport ManagementReport ManagementReport DeliveryReport Delivery

SQL Server Catalog

Report Server

XML Web Service Interface

Report Processing

Scheduling & Delivery

Delivery Targets(E-mail, SharePoint,

Custom)

Rendering

Output Formats (HTML, Excel, PDF, Custom)

Data Processing

Data Sources(SQL, OLE DB, XML/A, ODBC, Oracle, Custom)

Security

Security Services(NT, Passport,

Custom)

Office Custom ApplicationBrowser

Reporting Services ArchitectureReporting Services Architecture

New Features in New Features in Reporting ServicesReporting Services

Core Product ImprovementsCore Product Improvements

Better IntegrationBetter Integration

Rich Developer ExperienceRich Developer Experience

Empowering End UsersEmpowering End Users

Core Product ImprovementsCore Product Improvements

Direct client printingDirect client printing

End User SortEnd User Sort

Multivalued ParametersMultivalued Parameters

Custom Report ItemsCustom Report Items

Report Designer ImprovementsReport Designer Improvements

Direct Client PrintingDirect Client PrintingEnd User SortEnd User SortMultivalue ParametersMultivalue Parameters

Better IntegrationBetter Integration

Analysis Services Query DesignerAnalysis Services Query Designer

SQL Server Management Studio SQL Server Management Studio IntegrationIntegration

Share Point Reporting Web PartsShare Point Reporting Web Parts

Analysis Services Query DesignerAnalysis Services Query Designer

SQL Server Management Studio IntegrationSQL Server Management Studio Integration

Share Point Reporting Web PartsShare Point Reporting Web Parts

Rich Developer ExperienceRich Developer Experience

Visual Studio IntegrationVisual Studio Integration

Report Viewer ControlsReport Viewer ControlsWindows ApplicationWindows Application

ASP.NET ApplicationASP.NET Application

Visual Studio IntegrationVisual Studio Integration

Empowering End UsersEmpowering End Users

Report Builder ClientReport Builder Client

Report Builder Model DesignerReport Builder Model Designer

Report Builder ClientReport Builder Client

Report Builder Model DesignerReport Builder Model Designer

Ad-Hoc Reporting with Ad-Hoc Reporting with Report BuilderReport Builder

Report Builder ArchitectureReport Builder Architecture

Report Builder ClientReport Builder Client

Model DesignModel Design

Report Builder ArchitectureReport Builder Architecture

SQL Server CatalogSQL Server CatalogSQL Server CatalogSQL Server Catalog

Web Services InterfaceWeb Services InterfaceWeb Services InterfaceWeb Services Interface

Report ServerReport Server

Report BuilderReport BuilderClientClient

Report BuilderReport BuilderClientClient

ModelModelDesignerDesigner

ModelModelDesignerDesigner

Data Sources(SQL Server,

Analysis Services)

Drillthrough Report GenerationDrillthrough Report Generation

Query GenerationQuery Generation

ReportReport ManagerManager

ReportReport ManagerManager

ReportReportDesignerDesigner

ReportReportDesignerDesigner

SQL MgmtSQL MgmtStudioStudio

SQL MgmtSQL MgmtStudioStudio

Report Builder ClientReport Builder Client

Report Builder is a “Click Once” Windows Report Builder is a “Click Once” Windows application managed on the Report Serverapplication managed on the Report Server

Requires .NET Framework 2.0Requires .NET Framework 2.0

Users download and launch the client from Users download and launch the client from the Report Manager or 3rd party applicationsthe Report Manager or 3rd party applications

Built on top of familiar Microsoft Office Built on top of familiar Microsoft Office paradigms: Excel, PowerPointparadigms: Excel, PowerPoint

Reports built with report templates Reports built with report templates (textboxes, tables, matrices, charts)(textboxes, tables, matrices, charts)

Finished reports can be saved on the serverFinished reports can be saved on the server

Model DesignModel Design

Model Designer is interface for Model Designer is interface for designing/editing a modeldesigning/editing a model

New project type in BI Development StudioNew project type in BI Development Studio

Define fields and rolesDefine fields and roles

Define calculated fieldsDefine calculated fields

Organize modelOrganize model

Models can be auto-generated in Model Models can be auto-generated in Model Designer or on the Report ServerDesigner or on the Report Server

Generates entities, fields and roles based on Generates entities, fields and roles based on source metadatasource metadata

Auto-generation against SQL Server and Analysis Auto-generation against SQL Server and Analysis Services databasesServices databases

Report BuilderReport Builder

Summarize key pointsSummarize key points

Bundle with SQL Server 2005. Out of the box Bundle with SQL Server 2005. Out of the box solutionsolution

Protected your investment. Seamless Protected your investment. Seamless integration with Office, SPS, and .NETintegration with Office, SPS, and .NET

Complete reporting solution for the entire Complete reporting solution for the entire enterprise enterprise

Business users will be able to build or Business users will be able to build or modify reports outside of Visual Studiomodify reports outside of Visual Studio

Close the gap between IT and Business User Close the gap between IT and Business User with Report Builderwith Report Builder

Thank youThank you

Q & AQ & A