微软_SSRS_详细介绍文档
合集下载
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
SQL Server Reporting Services
What is SQL Server Reporting Services?
Reporting platform for both traditional and interactive reports Scalable, manageable and embeddable server infrastructure Integrated with Visual Studio, Office applications, browser and other familiar tools Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)
报表设计
MDX Query Builder
MDX 与数据挖掘的 查询设计器 MDX 参数的支持 支持服务器端的聚 合 与紧密集成 紧密集成
基于WEB方式的渲染
打印格式的输出
输出到EXCEL
发布到私人EMAIL
Product Architecture
Browser Office Custom Application
More info on the RDL spec: /sql/reporting
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
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.)
Data Sources (SQL, OLE DB, XML/A, ODBC, Oracle, Custom)
XML Web Service Interface Report Server
Report Processing
Security Services (NT, Passport, Custom)
Data ProcLeabharlann ssingSecurity
Rendering
Delivery
Output Formats (HTML, Excel, PDF, Custom)
SQL Server Catalog
Delivery Targets (E-mail, SharePoint, Custom)
Key Benefits
Authoring Management Delivery
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)
Open, extensible enterprise reporting platform Office System integration development environment Works with existing data sources Scalable, flexible and costcost-effective solution
Reporting Lifecycle
Reporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.
What is SQL Server Reporting Services?
Reporting platform for both traditional and interactive reports Scalable, manageable and embeddable server infrastructure Integrated with Visual Studio, Office applications, browser and other familiar tools Single platform and tools for all types of structured data (relational, hierarchical, multidimensional)
报表设计
MDX Query Builder
MDX 与数据挖掘的 查询设计器 MDX 参数的支持 支持服务器端的聚 合 与紧密集成 紧密集成
基于WEB方式的渲染
打印格式的输出
输出到EXCEL
发布到私人EMAIL
Product Architecture
Browser Office Custom Application
More info on the RDL spec: /sql/reporting
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
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.)
Data Sources (SQL, OLE DB, XML/A, ODBC, Oracle, Custom)
XML Web Service Interface Report Server
Report Processing
Security Services (NT, Passport, Custom)
Data ProcLeabharlann ssingSecurity
Rendering
Delivery
Output Formats (HTML, Excel, PDF, Custom)
SQL Server Catalog
Delivery Targets (E-mail, SharePoint, Custom)
Key Benefits
Authoring Management Delivery
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)
Open, extensible enterprise reporting platform Office System integration development environment Works with existing data sources Scalable, flexible and costcost-effective solution
Reporting Lifecycle
Reporting Services is an open and extensible platform supporting the authoring, management and delivery of rich, interactive reports to the entire enterprise.