sql server 2005 reporting services: product overview niran luckcanakul (mcsd, mcdba, mct) project...
TRANSCRIPT
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