Reporting Services 工具Reporting Services Tools

[SQL Server]SQL Server Reporting ServicesReporting Services 包含一組圖形和指令碼工具,支援在受管理的環境中開發與使用豐富的報表功能。Reporting ServicesReporting Services contains a set of graphical and scripting tools that support the development and use of rich reports in a managed environment. 此工具集包含開發工具、組態與管理工具,以及報表檢視工具。The tool set includes development tools, configuration and administration tools, and report viewing tools. 本主題提供 Reporting ServicesReporting Services 中各個工具與其存取方式的簡短概觀。This topic gives a brief overview of each tool in Reporting ServicesReporting Services and how it can be accessed.

若要立即找到工具,請參閱教學課程:如何尋找及啟動 Reporting Services 工具(SSRS)To find a tool right away, see Tutorial: How to Locate and Start Reporting Services Tools (SSRS).

報表撰寫工具Tools for Report Authoring

下表列出 [SQL Server]SQL Server Reporting ServicesReporting Services中可用於報表撰寫的工具。The following table lists the available tools for report authoring in [SQL Server]SQL Server Reporting ServicesReporting Services.

工具Tool 描述Description 如何存取How to access
Power ViewPower View 互動式的資料探索和視覺呈現體驗設計為可讓您建立以及與依據 Analysis ServicesAnalysis Services 表格式模型的報表進行互動。An interactive data exploration and visual presentation experience designed to let you create and interact with reports based on Analysis ServicesAnalysis Services tabular models.

注意:需要Reporting ServicesReporting Services以 SharePoint 模式。Note: Requires Reporting ServicesReporting Services in SharePoint mode.
Sliverlight 瀏覽器Browser with Silverlight.
報表設計師Report Designer 使用此工具設計報表並部署至原生模式或 SharePoint 報表伺服器。Use this tool to design reports and deploy to a native mode or SharePoint mode report server.

裝載於 SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)Hosted in SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)

報表資料窗格可組織用於報表的資料Report Data pane to organize data used in your report

互動式報表設計之 [設計] 和 [預覽] 的索引標籤式檢視Tabbed views for Design and Preview for interactive report design

查詢設計工具可協助您指定要從資料來源擷取的資料,且此資料來源與 RSReportDesigner 組態檔中資料來源類型相關聯。Query designers to help specify which data to retrieve from data sources and that are associated with data source types in the RSReportDesigner Configuration File

使用智慧感知的運算式編輯器可建立自訂報表內容和外觀的 Visual BasicVisual Basic 運算式Expression editor with IntelliSense to build Visual BasicVisual Basic expressions that customize report content and appearance

支援自訂報表項目和自訂查詢設計工具Supports custom report items and custom query designers



如需詳細資訊,請參閱 SQL Server Data Tools (SSDT) 中的 Reporting ServicesFor more information, see Reporting Services in SQL Server Data Tools (SSDT).
SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT)
報表產生器Report Builder 使用此工具設計報表並部署至原生模式或 SharePoint 報表伺服器。Use this tool to design reports and deploy to a native mode or SharePoint mode report server.

MicrosoftMicrosoft Office 相似的撰寫環境MicrosoftMicrosoft Office-like authoring environment

將報表項目儲存為報表組件的能力Ability to save report items as report parts

建立地圖精靈A wizard for creating maps

彙總的彙總Aggregates of aggregates

增強的運算式支援Enhanced support for expressions

查詢設計工具可協助您指定要從內建資料來源類型擷取的資料Query designers to help specify which data to retrieve from a selection of built-in data sources types



如需詳細資訊,請參閱 < 報表產生器(SSRS)For more information, see Report Builder (SSRS).
下載 MSI 或從報表管理員/SharePoint 開啟Download MSI or open from Report Manager/SharePoint

適用於報表伺服器管理的工具Tools for Report Server Administration

一組圖形和指令碼工具可用於管理 [SQL Server]SQL Server Reporting ServicesReporting Services中的報表伺服器。A set of graphical and scripting tools are available for administering the report server in [SQL Server]SQL Server Reporting ServicesReporting Services. 所使用工具取決於報表伺服器的部署模式。The tools that you use depend on the deployment mode of your report server.

原生模式Native Mode

下表列出可用以管理部署於原生模式中報表伺服器的工具。The following table lists the available tools for administering the report server that is deployed in native mode.

工具Tool 描述Description 如何存取How to access
Reporting Services 組態管理員Reporting Services Configuration Manager 請使用此工具設定 Reporting Services 安裝。Use this tool to configure a Reporting Services installation. 請注意,Reporting Services 組態管理員無法幫您管理報表伺服器內容、 啟用其他功能,或授與伺服器的存取權。Note that the Reporting Services Configuration Manager does not help you manage report server content, enable additional features, or grant access to the server. 可用的工作包括:Available tasks include:

設定本機和遠端報表伺服器執行個體Configuring both local and remote report server instances

設定報表伺服器服務帳戶。Configuring the Report Server service account.

建立及設定一個或多個 Web 服務 URL。Creating and configuring one or more Web service URL.

設定報表管理員 URL。Configuring the Report Manager URL

建立及設定報表伺服器資料庫。Creating and configuring the report server database.

設定向外延展部署。Configuring a scale-out deployment.

備份、還原或取代用於加密已儲存之連接字串和認證的對稱金鑰。Backup, restoring, or replacing the symmetric key that is used to encrypt stored connection strings and credentials.

設定自動執行帳戶。Configuring the unattended execution account.

設定電子郵件傳遞的 SMTP 伺服器。Configuring an SMTP server for e-mail delivery.



如需詳細資訊,請參閱 Reporting Services 組態管理員 (原生模式)For more information, see Reporting Services Configuration Manager (Native Mode).
開始功能表Start menu
SQL Server Management StudioSQL Server Management Studio 使用此工具即可在單一環境中管理一個或多個報表伺服器執行個體,包括:Use this tool to manage one or more report server instances in a single environment, including:

管理本機和遠端報表伺服器執行個體Managing both local and remote report server instances

設定報表伺服器屬性Setting report server properties

修改角色定義Modifying role definitions

關閉您不要使用的報表伺服器功能Turning off report server features you are not using

管理作業Managing jobs

管理共用排程Managing shared schedules
開始功能表Start menu
SQL Server 組態管理員SQL Server Configuration Manager 使用此工具可以:Use this tool to:

啟動及停止 Reporting Services Windows 服務Start and stop the Reporting Services Windows services

設定客戶回函報表、傾印目錄位置和錯誤報告Configure Customer Feedback Reporting, the dump directory location, and error reporting



**** 警告* * **請勿使用此工具來設定服務帳戶。** Warning ** Do not use this tool to configure service account. 請改用 Reporting Services 組態工具。Use the Reporting Services Configuration tool instead.

如需詳細資訊,請參閱 SQL Server 組態管理員For more information, see SQL Server Configuration Manager.
開始功能表Start menu
Rsconfig 公用程式Rsconfig Utility 使用此工具可設定及管理連線到報表伺服器資料庫的報表伺服器。Use this tool to configure and manage a report server connection to the report server database. 您也可以使用它來指定自動執行報表處理所使用的使用者帳戶。You can also use it to specify a user account to use for unattended report processing.

如需詳細資訊,請參閱報表伺服器命令提示字元公用程式 (SSRS)For more information, see Report Server Command Prompt Utilities (SSRS).
命令提示字元Command prompt
Rskeymgmt 公用程式Rskeymgmt Utility 使用此工具可以:Use this tool to:

擷取、還原、建立及刪除用於加密報表伺服器資料的對稱金鑰Extract, restore, create, and delete the symmetric key used to encrypt report server data

在向外延展部署中加入報表伺服器執行個體Join report server instances in a scale-out deployment



如需詳細資訊,請參閱報表伺服器命令提示字元公用程式 (SSRS)For more information, see Report Server Command Prompt Utilities (SSRS).
命令提示字元Command prompt
Windows Management Instrumentation (WMI) 類別Windows Management Instrumentation (WMI) Classes 使用這些類別可自動化 Reporting Services 組態管理員中的組態工作,且無須使用圖形化使用者介面。Use these classes to automate the configuration tasks in Reporting Services Configuration Manager without the need to use the graphical user interface.

如需詳細資訊,請參閱 以程式設計方式存取 WMI 提供者For more information, see Accessing the WMI Provider Programmatically.
Visual Basic 指令碼Visual Basic script

SharePoint 整合模式SharePoint Integrated Mode

在 SharePoint 模式中,Reporting Services 是在 SharePoint 架構中的服務應用程式,並且直接透過 SharePoint 進行管理In SharePoint mode, the Reporting Services is a service application in the SharePoint architecture, and is administered directly through SharePoint

工具Tool 描述Description 如何存取How to access
SharePoint 管理中心SharePoint Central Administration 使用 SharePoint 管理中心可建立、查詢及管理 Reporting ServicesReporting Services的共用服務應用程式。Use SharePoint Central Administration to create, query, and manage the shared service applications for Reporting ServicesReporting Services.

如需詳細資訊,請參閱設定和管理報表伺服器 (Reporting Services SharePoint 模式)For more information, see Configuration and Administration of a Report Server (Reporting Services SharePoint Mode).
前往管理中心之 SharePoint 網站 URL 的瀏覽器Browser to the SharePoint site URL for Central Administration
PowerShell CmdletPowerShell Cmdlets 使用 PowerShell Cmdlet 可建立、查詢及管理 Reporting ServicesReporting Services的共用服務應用程式。Use PowerShell cmdlets to create, query, and manage the shared service applications for Reporting ServicesReporting Services.

如需詳細資訊,請參閱 Reporting Services SharePoint 模式的 PowerShell CmdletFor more information, see PowerShell cmdlets for Reporting Services SharePoint Mode.
SharePoint 2010 管理命令介面SharePoint 2010 Management Shell

用於報表內容管理的工具Tools for Report Content Management

一組圖形和指令碼工具可用於管理 [SQL Server]SQL Server Reporting ServicesReporting Services中的內容。A set of graphical and scripting tools are available for managing content in [SQL Server]SQL Server Reporting ServicesReporting Services. 所使用工具取決於報表伺服器的部署模式。The tools that you use depend on the deployment mode of your report server.

工具Tool 描述Description 如何存取How to access
報表伺服器 Web 服務 URLReport Server Web service URL 使用此工具可在一般項目瀏覽頁面的報表目錄中瀏覽內容。Use this tool to browse content in the report catalog in a generic item navigation page.

如需詳細資訊,請參閱 Report Server Web ServiceFor more information, see Report Server Web Service.
瀏覽器Browser
報表管理員Report Manager (僅限於原生模式) 使用此工具可從遠端位置透過 HTTP 連線管理單一報表伺服器執行個體。(Native mode only) Use this tool to administer a single report server instance from a remote location over an HTTP connection. 您可以執行下列工作:You can do the following:

檢視、搜尋、列印與訂閱報表。View, search, print, and subscribe to reports.

建立、保護和維護資料夾階層,以組織伺服器上的項目。Create, secure, and maintain the folder hierarchy to organize items on the server.

設定以角色為基礎的安全性,此安全性決定對項目與作業的存取權。Configure role-based security that determines access to items and operations.

設定報表執行屬性、報表記錄和報表參數。Configure report execution properties, report history, and report parameters.

建立可連接並可從 Microsoft SQL Server Analysis Services 資料來源或從 SQL Server 關聯式資料來源擷取資料的報表模型。Create report models that connect to and retrieve data from a Microsoft SQL Server Analysis Services data source or from a SQL Server relational data source.

設定模型項目安全性以存取模型中的特定項目,或將項目對應到您事先建立之預先定義的點選連結報表。Set model item security to allow access to specific entities in the model, or map entities to predefined clickthrough reports that you create in advance.

建立共用排程與共用資料來源,讓排程與資料來源連接更容易管理。Create shared schedules and shared data sources to make schedules and data source connections more manageable.

建立資料驅動訂閱,將報表傳遞至大型收件者清單。Create data-driven subscriptions that roll out reports to a large recipient list.

建立連結報表,以重複使用並以不同的方式重新決定現有報表的用途。Create linked reports to reuse and repurpose an existing report in different ways.

啟動報表產生器來建立可以在報表伺服器上儲存與執行的報表。Launch Report Builder to create reports that you can save and run on the report server.



如需詳細資訊,請參閱報表管理員 (SSRS 原生模式)For more information, see Report Manager (SSRS Native Mode).
RS 公用程式RS Utility 此工具是您可用於執行編寫指令碼作業的 Script Host。This tool is a script host that you can use to perform scripted operations. 使用此工具即可執行 Visual BasicVisual Basic 指令碼,於報表伺服器資料庫間複製資料、發行報表、在報表伺服器資料庫中建立項目等等。Use this tool to run Visual BasicVisual Basic scripts that copy data between report server databases, publish reports, create items in a report server database, and more.

如需詳細資訊,請參閱報表伺服器命令提示字元公用程式 (SSRS)For more information, see Report Server Command Prompt Utilities (SSRS).
命令提示字元Command prompt

另請參閱See Also

Reporting Services Report Server Reporting Services Report Server
Reporting Services 概念 (SSRS) Reporting Services Concepts (SSRS)
Reporting Services (SSRS)Reporting Services (SSRS)