建立、修改及刪除共用資料來源 (SSRS)Create, Modify, and Delete Shared Data Sources (SSRS)

共用資料來源是一組資料來源連接屬性,可供多個報表、模型以及在 Reporting ServicesReporting Services 報表伺服器上執行的資料驅動訂閱參考。A shared data source is a set of data source connection properties that can be referenced by multiple reports, models, and data-driven subscriptions that run on a Reporting ServicesReporting Services report server. 共用資料來源提供一種簡單的方式,可用來管理通常會隨著時間而變更的資料來源屬性。Shared data sources provide an easy way to manage data source properties that often change over time. 如果使用者帳戶或密碼變更,或者如果您將資料庫移到不同的伺服器,可以在一個地方更新連接資訊。If a user account or password changes, or if you move the database to a different server, you can update the connection information in one place.

對於報表以及資料驅動訂閱而言,共用資料來源是選擇性的,但是對於報表模型而言,則是必要的。Shared data sources are optional for reports and data-driven subscriptions, but required for report models. 如果您打算將報表模型用於隨選報表,您必須建立並維護一個共用資料來源項目,才能提供連接資訊給模型。If you plan to use report models for ad hoc reporting, you must create and maintain a shared data source item to provide connection information to the model.

共用資料來源包含下列部分:A shared data source consists of the following parts:

部分Part 描述Description
[屬性]Name 識別報表伺服器資料夾階層中之項目的名稱。A name that identifies the item within the report server folder hierarchy.
描述Description 檢視資料夾的內容時,與入口網站中的項目一起顯示的描述。A description that appears with the item in the web portal when you view the contents of the folder.
連接類型Connection type 與資料來源搭配使用的資料處理延伸模組。The data processing extension used with the data source. 您僅能使用在報表伺服器上部署的資料處理延伸模組。You can only use data processing extensions that are deployed on the report server. 如需 Reporting ServicesReporting Services 隨附之資料處理延伸模組的詳細資訊,請參閱 Reporting Services (SSRS) 支援的資料來源For more information about data processing extensions included with Reporting ServicesReporting Services, see Data Sources Supported by Reporting Services (SSRS).
連接字串Connection string 資料庫的連接字串。The connection string for the database. 如需詳細資訊,或者要檢視常用資料來源之連接字串的範例,請參閱 資料連接、資料來源及連接字串 (報表產生器和 SSRS)For more information and to view examples of connection strings to frequently used data sources, see Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS).
認證類型Credential type 指定如何取得用於連接的認證,以及建立連接後是否要使用這些認證。Specifies how credentials are obtained for the connection and whether they are to be used after the connection is made. 如需詳細資訊,請參閱 指定報表資料來源的認證及連接資訊For more information, see Specify Credential and Connection Information for Report Data Sources.

共用資料來源不包含用來擷取資料的查詢資訊。A shared data source does not contain query information used to retrieve data. 查詢永遠會保留在報表定義中。The query is always kept within a report definition.

建立與刪除共用資料來源Creating and Modifying Shared Data Sources

若要建立共用資料來源或修改其屬性,您必須擁有報表伺服器的 [管理資料來源] 權限。To create a shared data source or modify its properties, you must have Manage data sources permissions on the report server. 如果報表伺服器是在原生模式下執行,您可以使用入口網站來建立與設定共用資料來源。If the report server runs in native mode, you can create and configure the shared data source in the web portal. 如果報表伺服器是在 SharePoint 整合模式下執行,您可以使用 SharePoint 網站上的應用程式頁面。If the report server runs in SharePoint integrated mode, you can use the application pages on a SharePoint site. 如果是任意模式下的任何報表伺服器,您可以在「報表設計師」中建立共用資料來源,然後將其發行到目標伺服器上。For any report server regardless of its mode, you can create a shared data source in Report Designer and then publish it to a target server.

在報表伺服器上建立共用資料來源之後,您可以建立角色指派來控制其存取權、將其移動到不同的位置、重新命名它,或者在外部資料來源執行維護作業時離線以防進行報表處理。After you create a shared data source on the report server, you can create role assignments to control access to it, move it to a different location, rename it, or take it offline to prevent report processing while maintenance operations are performed on the external data source. 如果您重新命名或移動共用資料來源項目至報表伺服器資料夾階層中的其他位置,所有參考共用資料來源的報表或訂閱,其相關路徑資訊會隨之更新。If you rename or move a shared data source item to another location in the report server folder hierarchy, the path information in all reports or subscriptions that reference the shared data source are updated accordingly. 如果您讓共用資料來源離線,所有報表、模型和訂閱都不會執行,直到您重新啟用資料來源為止。If you take the shared data source offline, all reports, models, and subscriptions will not run until you re-enable the data source.

如需在報表伺服器資料夾階層控制共用資料來源存取權的詳細資訊,請參閱 保護共用資料來源項目的安全For more information about controlling access to shared data sources in the report server folder hierarchy, see Secure Shared Data Source Items.

在報表設計師中建立共用資料來源To create a shared data source in Report Designer

  1. 在 [報表資料] 窗格的工具列上,按一下 [新增] ,然後按一下 [資料來源]On the toolbar in the Report Data pane, click New and then click Data Source. [資料來源屬性] 對話方塊隨即開啟。The Data Source Properties dialog box opens.

    注意

    如果看不到 [報表資料] 窗格,請按一下 [檢視] 功能表上的 [報表資料]。If the Report Data pane is not visible, click Report Data on the View menu.

  2. [名稱] 文字方塊中,輸入資料來源的名稱或接受預設值。In the Name text box, type a name for the data source or accept the default. 資料來源名稱是在報表內部使用。The data source name is used internally within the report. 為了清楚起見,我們建議資料來源的名稱要包含連接字串中所指定的資料庫名稱。For clarity, we recommend that the name of the data source contain the name of the database specified in the connection string.

  3. 請確認已選取 [使用共用資料來源參考],然後執行下列動作。Verify that Use shared data source reference is selected and then do the following.

    1. 按一下 [新增]Click New. 在 [共用資料來源] 屬性對話方塊中,遵循步驟 2 和 3 來建立新的資料來源。In the Shared Data Source properties dialog box, follow steps 2 and 3 to create a new data source.

    2. 按一下 [確定] 。Click OK.

      新的共用資料來源會出現在 [方案總管] 的 [共用資料來源] 資料夾中。The new shared data source appears in the Shared Data Sources folder in Solution Explorer.

  4. 按一下 [認證]Click Credentials.

    指定用於這個資料來源的認證。Specify the credentials to use for this data source. 資料來源的擁有者會選擇支援的認證類型。The owner of the data source chooses the type of credentials that are supported.

    在入口網站中建立共用資料來源To create a shared data source in the web portal

  5. 在入口網站中,選取 [新增] > [資料來源]。In the web portal, select New > Data Source.

  6. 輸入項目的名稱。Type a name for the item. 名稱必須至少包含一個字元,而且開頭必須為字母。A name must contain at least one character and it must start with a letter. 它也可以包含特定符號,但不能包含空格或下列字元:; ?It can also include certain symbols, but not spaces or the characters ; ? : @ & = + , $ / * < > | " /。: @ & = + , $ / * < > | " /.

  7. 選擇性地鍵入描述,以提供使用者連線的相關資訊。Optionally type a description to provide users with information about the connection..

  8. 在 [資料來源類型] 清單中,指定用來處理資料來源中之資料的資料處理延伸模組。In the Data source type list, specify the data processing extension that is used to process data from the data source.

  9. 針對 [連接字串],指定報表伺服器用於連線到資料來源的連接字串。For Connection string, specify the connection string that the report server uses to connect to the data source. 建議您不要在連接字串中指定認證。We recommend not specifying credentials in the connection string.

    下列範例將說明用以連線至本機 SQL ServerSQL Server AdventureWorks2016 資料庫的連接字串:The following example illustrates a connection string for connecting to the local SQL ServerSQL Server AdventureWorks2016 database:

    data source=<localservername>; initial catalog=AdventureWorks2016 
    
  10. 針對 [使用下列方式連接],指定報表執行時要如何取得認證:For Connect using, specify how credentials are obtained when the report runs:

    • 如果您要提示使用者輸入登入名稱和密碼,請按一下 [執行報表的使用者所提供的認證]If you want to prompt the user for a logon name and password, click Credentials supplied by the user running the report. 若要使用使用者所輸入的認證作為 Windows 認證,請按一下 [連線到資料來源時作為 Windows 認證]。To use the credentials that the user enters as Windows credentials, click Use as Windows credentials when connecting to the data source. 如果使用者名稱和密碼是資料庫認證,請勿選取此選項。If the user name and password are database credentials, do not select this option.

    • 如果您打算將資料來源當作具有資料來源擁有者所管理之預存認證的共用資料來源,或是在支援訂閱或其他已排程之作業 (例如自動化報表記錄產生) 的報表中使用資料來源,請按一下 [安全地儲存在報表伺服器中的認證]。If you intend to use the data source as a shared data source with saved credentials that are managed by the owner of the data source, or for reports that support subscriptions or other scheduled operations (such as automated report history generation), click Credentials stored securely in the report server. 如果資料庫伺服器支援模擬或委派,您就可以選取 [連接到資料來源後,模擬已驗證的使用者]If the database server supports impersonation or delegation, you can select Impersonate the authenticated user after a connection has been made to the data source.

    • 對於存取報表的使用者提供的認證,若要讓報表伺服器將認證傳送給主控外部資料來源的伺服器,請按一下 [Windows 整合式安全性]If you want the report server to pass the credentials of the user accessing the report to the server hosting the external data source, click Windows Integrated Security. 在此情況下,不會提示使用者輸入使用者名稱或密碼。In this case, the user is not prompted to type a user name or password.

    • 如果資料來源沒有使用認證 (例如,如果資料來源是從檔案系統存取的 XML 檔),請按一下 [不需要認證]。If the data source does not use credentials (for example, if the data source is an XML file that is accessed from the file system), click Credentials are not required. 只有當這種認證類型適用於資料來源時,您才應該指定此認證類型。You should only specify this credential type if it is valid for the data source. 如果您針對需要驗證的資料來源選取此選項,連接將會失敗。If you select this option for a data source that requires authentication, the connection will fail. 如果您選取此選項,請務必設定自動執行帳戶,以便在使用者認證無法使用時,允許報表伺服器連接至其他電腦以擷取資料或檔案。If you select this option, be sure to configure the unattended execution account that allows the report server to connect to other computers to retrieve data or files when user credentials are not available.

      如需設定認證的詳細資訊,請參閱 指定報表資料來源的認證及連接資訊For more information about configuring credentials, see Specify Credential and Connection Information for Report Data Sources. 如需自動執行帳戶的詳細資訊,請參閱設定自動執行帳戶 (SSRS 設定管理員)For more information about the unattended execution account, see Configure the Unattended Execution Account (SSRS Configuration Manager).

  11. 按一下 [測試連線] 按鈕,驗證資料來源設定。Click the Test Connection button to validate the data source configuration.

    注意

    [測試連接] 按鈕不支援 XML 資料來源類型。The Test Connection button is not supported for the XML data source type.

  12. 按一下 [確定]Click OK

    在入口網站中修改共用資料來源To modify a shared data source in the web portal

  13. 在入口網站中,巡覽至共用資料來源。In the web portal, navigate to the shared data source.

  14. 選取共用資料來源右上角的省略符號 (...) > [管理]。Select the ellipsis (...) in the upper-right corner of the shared data source > Manage.

    [屬性] 頁面隨即開啟。The Properties page opens.

  15. 修改資料來源,然後按一下 [套用]。Modify the data source, and then click Apply.

刪除共用資料來源Deleting Shared Data Sources

您可以利用從報表伺服器刪除任何項目的相同方式,刪除共用資料來源。You can delete a shared data source the same way that you delete any item from the report server.

若要刪除共用資料來源To delete a shared data source

  1. 在入口網站中,巡覽至共用資料來源。In the web portal, navigate to the shared data source.

  2. 選取共用資料來源右上角的省略符號 (...) > [管理]。Select the ellipsis (...) in the upper-right corner of the shared data source > Manage.
    [屬性] 頁面隨即開啟。The Properties page opens.

  3. 按一下 [刪除],然後按一下 [確定]。Click Delete, and then click OK.

刪除共用資料來源會停用使用共用資料來源的所有報表、模型或資料驅動訂閱。Deleting a shared data source deactivates any report, model, or data-driven subscription that uses it. 如果沒有資料來源連接資訊,這些項目就無法再執行Without the data source connection information, the items will no longer run. 若要啟動這些項目,您必須開啟每個項目,並執行下列動作:To activate these items, you must open each one and do the following:

  • 若是參考共用資料來源的報表和資料驅動訂閱,您可以在報表屬性或訂閱中指定資料來源連接資訊,或者選取其中包含您要使用之值的新共用資料來源。For reports and data-driven subscriptions that reference the shared data source, you can specify data source connection information in report properties or subscription, or you can select a new shared data source that has the values you want to use.

  • 若是模型或使用該模型的「報表產生器」報表,您必須指定一個新的共用資料來源。For models and Report Builder reports that use that model, you must specify a new shared data source. 這些模型僅能透過共用資料來源取得資料來源連接資訊。Models get data source connection information only through shared data sources.

    刪除共用資料來源時,沒有「復原」作業。There is no Undo operation for deleting a shared data source. 不過,如果您不小心刪除了共用資料來源,可以使用相同的屬性值來建立一個新的共用資料來源。However, if you accidentally delete a shared data source, you can create a new one using the same property values as the one you deleted. 您必須開啟每個報表、模型和資料驅動訂閱,才能在使用它的項目中重建共用資料來源,但是,只要資料來源屬性與之前的資料來源屬性相同,報表、模型和訂閱就會如先前般運作。You will have to open each report, model, and data-driven subscription to rebind the shared data source to the item that uses it, but as long as the data source properties are the same as before, the reports, models, and subscriptions will continue to function as before.

匯入共用資料來源Importing Shared Data Sources

若要在報表設計師中匯入現有的資料來源To import an existing data source in Report Designer

  1. 在方案總管中,以滑鼠右鍵按一下報表伺服器專案中的 [共用資料來源] 資料夾,然後按一下 [加入現有項目]。In Solution Explorer, right-click the Shared Data Sources folder in the report server project, and then click Add Existing Item. [新增現有項目] 對話方塊隨即開啟。The Add Existing Item dialog box opens.

  2. 巡覽至現有的報表定義共用資料來源 (rds) 檔案,然後按一下 [開啟]。Navigate to an existing Report Definition Shared data source (rds) file and then click Open.

  3. 按一下 [確定] 。Click OK.

SharePoint 中的共用資料來源Shared Data Sources in SharePoint

當您從 SharePoint 文件庫執行報表時,可以在報表內部或連結到報表的外部檔案中定義連接資訊。When you run a report from a SharePoint library, connection information can be defined inside the report or in an external file that is linked to the report. 如果連接資訊內嵌於報表中,它就稱為自訂資料來源。If the connection information is embedded within the report, it is called a custom data source. 如果連接資訊定義於外部檔案中,它就稱為共用資料來源。If the connection information is defined in an external file, it is called a shared data source. 外部檔案可以是報表伺服器資料來源 (.rsds) 檔案或 Office 資料連線 (.odc) 檔案。The external file can be a report server data source (.rsds) file or an Office Data Connection (.odc) file.

.rsds 檔類似 .rds 檔,但結構描述不同。An .rsds file is similar to an .rds file, but it has a different schema. 若要建立 .rsds 檔,您可以將 .rds 檔從報表設計師或模型設計師中發行到 SharePoint 文件庫 (便會根據原始 .rds 檔建立新的 .rsds 檔)。To create an .rsds file, you can publish an .rds from Report Designer or Model Designer to a SharePoint library (a new .rsds file is created from the original .rds file). 或者,您可以在 SharePoint 網站的文件庫中建立新檔案。Or, you can create a new file in a library on a SharePoint Site.

當您建立或發行共用資料來源之後,就可以編輯連接屬性,而且如果已經不需要,還可以刪除該檔案。After you create or publish a shared data source, you can edit connection properties or delete the file if it is no longer used. 刪除共用資料來源之前,您應該先判斷是否有報表和報表模型使用此共用資料來源。Before you delete a shared data source, you should determine whether it is used by reports and report models. 您可以檢視參考到共用資料來源的相依項目來判斷。You can do this by viewing dependent items that reference the shared data source.

雖然相依項目清單會告訴您是否有項目參考到共用資料來源,但是並不會告訴您此項目目前是否使用中。Although the list of dependent items tells you whether the shared data source is referenced, it does not tell you whether the item is actively used. 若要判斷共用資料來源或模型目前是否使用中,您可以檢閱報表伺服器電腦上的記錄檔。To determine whether the shared data source or model is actively used, you can review the log files on the report server computer. 如果您無法存取這些記錄檔,或者這些檔案沒有包含所需的資訊,請考慮在您判斷報表的實際狀態時,將報表移至無法存取的資料夾。If you do not have access to the log files or if the files do not contain the information you want, consider moving the report to an inaccessible folder while you determine its actual status.

若要建立共用資料來源 (.rsds) 檔案 (SharePoint 2010)To create a shared data source (.rsds) file (SharePoint 2010)

  1. 按一下文件庫功能區上的 [文件] 索引標籤。Click the Documents tab on the library ribbon.

  2. 在 [新增文件] 功能表上,按一下 [報表資料來源]On the New Document menu, click Report Data Source

    注意

    如果您沒有在功能表上看見 [報表資料來源] 項目,表示報表資料來源內容類型尚未啟用。If you do not see the Report Data Source item on the menu, the report data source content type has not been enabled. 如需詳細資訊,請參閱 將 Reporting Services 內容類型加入至 SharePoint 文件庫For more information, see Add Reporting Services Content Types to a SharePoint Library.

  3. 在 [名稱] 中,輸入 .rsds 檔的描述性名稱。In Name, enter a descriptive name for the .rsds file.

  4. 在 [資料來源類型] 的清單中,選取資料來源的類型。In Data Source Type, select the type of data source from the list. 如需詳細資訊,請參閱 Reporting Services (SSRS) 支援的資料來源For more information, see Data Sources Supported by Reporting Services (SSRS).

  5. 在 [連接字串] 中,指定資料來源的指標以及其他建立外部資料來源連線必要的任何設定。In Connection String, specify a pointer to the data source and any other settings that are necessary for establishing a connection to the external data source. 您所使用的資料來源類型會決定連接字串的語法。The type of data source you are using determines the syntax of the connection string. 如需詳細資訊和範例,請參閱 資料連接、資料來源及連接字串 (報表產生器和 SSRS)For more information and examples, see Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS).

  6. 在 [認證] 中,指定報表伺服器取得認證來存取外部資料來源的方式。In Credentials, specify how the report server obtains credentials to access the external data source. 認證可以針對自動報表處理而儲存、提示、整合或設定。Credentials can be stored, prompted, integrated, or configured for unattended report processing.

    • 如果您想要使用開啟報表之使用者的認證來存取資料,請選取 [Windows 驗證 (整合式)]。Select Windows authentication (integrated) if you want to access the data using the credentials of the user who opened the report. 如果 SharePoint 網站或伺服陣列使用表單驗證或透過受信任帳戶連接到報表伺服器,請勿選取這個選項。Do not select this option if the SharePoint site or farm uses forms authentication or connects to the report server through a trusted account. 如果您想要排程這個報表的訂閱或資料處理,請勿選取這個選項。Do not select this option if you want to schedule subscription or data processing for this report. 在針對網域啟用 Kerberos 驗證時,或者資料來源與報表伺服器是在同一部電腦上時,此選項具有最佳的效能。This option works best when Kerberos authentication is enabled for your domain, or when the data source is on the same computer as the report server. 如果未啟用 Kerberos 驗證,Windows 認證只能傳遞至一部其他電腦。If Kerberos authentication is not enabled, Windows credentials can only be passed to one other computer. 這表示,如果外部資料來源位於另一部需要其他連接的電腦上,您就會收到錯誤而非所預期的資料。This means that if the external data source is on another computer, requiring an additional connection, you will get an error instead of the data you expect.

    • 如果您希望使用者在每次執行報表時輸入自己的認證,請選取 [提示認證]。Select Prompt for credentials if you want the user to enter his or her credentials each time he or she runs the report. 如果您想要排程這個報表的訂閱或資料處理,請勿選取這個選項。Do not select this option if you want to schedule subscription or data processing for this report.

    • 如果您想要使用單一認證集來存取這個資料,請選取 [預存認證]。Select Stored credentials if you want to access the data using a single set of credentials. 認證會先經過加密,然後再儲存。The credentials are encrypted before they are stored. 您可以選取決定預存認證之驗證方式的選項。You can select options that determine how the stored credentials are authenticated. 如果預存認證屬於 Windows 使用者帳戶,請選取 [當做 Windows 認證使用]。Select Use as Windows credentials if the stored credentials belong to a Windows user account. 如果您想在資料庫伺服器上設定執行內容,請選取 [設定執行內容到這個帳戶]。Select Set execution context to this account if you want to set the execution context on the database server. 針對 SQL ServerSQL Server 資料庫,此選項會設定 SETUSER 函數。For SQL ServerSQL Server databases, this option sets the SETUSER function. 如需詳細資訊,請參閱 SETUSER (Transact-SQL)For more information, see SETUSER (Transact-SQL).

    • 如果您想要在連接字串中指定認證,或是想要使用報表伺服器上設定的最低權限帳戶來執行報表,請選取 [不需要認證]。Select Credentials are not required if you want to specify credentials in the connection string, or if you want to run the report using a least-privilege account that is configured on the report server. 如果這個帳戶並未在報表伺服器上設定,系統就會提示使用者輸入認證,而且您針對該報表定義的所有排程作業將不會執行。If this account is not configured on the report server, users will be prompted for credentials and any scheduled operations that you define for the report will not run.

  7. 如果您想要讓資料來源成為使用中,請選取 [啟用此資料來源]。Select Enable this data source if you want the data source to be active. 如果資料來源已設定,但是非使用中,當使用者嘗試使用以資料來源為基礎的報表時,他們就會看見錯誤訊息。If the data source is configured but not active, users will see an error message when they attempt to use a report based on the data source.

  8. 按一下 [測試連線] 按鈕,驗證資料來源設定。Click the Test Connection button to validate the data source configuration.

    注意

    [測試連接] 按鈕不支援 XML 資料來源類型。The Test Connection button is not supported for the XML data source type.

  9. 按一下 [確定],儲存建立的共用資料來源。Click OK to save create the shared data source.

    刪除共用資料來源 (.rsds) 檔案To delete a shared data source (.rsds) file

  10. 開啟包含 .rsds 檔案的文件庫。Open the library that contains the .rsds file.

  11. 指向共用資料來源。Point to the shared data source.

  12. 按一下即可顯示向下箭頭,然後按一下 [刪除]。Click to display a down arrow, and click Delete.

    如果您不小心刪除了想要保留的共用資料來源,可以建立包含相同連接資訊的新共用資料來源。If you mistakenly delete a shared data source that you meant to keep, you can create a new one that contains the same connection information. 在您重新建立共用資料來源之後,就必須開啟使用該資料來源的每個報表和模型,然後選取共用資料來源。After you recreate the shared data source, you must open each report and model that used that data source and select the shared data source. 新的共用資料來源項目的名稱、認證或連接字串語法可以與之前刪除的資料來源不同。The new shared data source item can have a different name, credentials, or connection string syntax from the one you delete. 只要連接解析成相同的資料來源,資料來源屬性可能會與原始值不同。As long as the connection resolves to the same data source, data source properties can vary from the original values.

    刪除報表模型時,請特別小心。Use caution when deleting a report model. 如果您刪除模型,就不能再於報表產生器中,開啟和修改以該模型為基礎的任何報表。If you delete a model, you can no longer open and modify any reports that are based on that model in Report Builder. 如果您不慎刪除了現有報表所使用的模型,就必須重新產生該模型,重新建立並儲存使用該模型的任何報表,然後重新指定想要使用的任何模型項目安全性。If you inadvertently delete a model that is used by existing reports, you must regenerate the model, re-create and save any reports that use the model, and re-specify any model item security that you want to use. 您不能只是重新產生模型,然後將它附加到現有的報表。You cannot simply regenerate the model and then attach it to an existing report.

相依項目Dependent Items

若要檢視使用資料來源之報表和模型的清單,開啟共用資料來源的 [相依項目] 頁面。To view a list of reports and models that use the data source, open the Dependent Items page for the shared data source. 當您在入口網站或 SharePoint 應用程式頁面中開啟資料來源時,您可以存取此頁面。You can access this page when you open the data source in the web portal or a SharePoint application page. 請注意,[相依項目] 頁面中不會顯示資料驅動訂閱。Note that the Dependent Items page does not show data-driven subscriptions. 如果共用資料來源是由訂閱所使用,訂閱將不會出現在相依項目清單中。If a shared data source is used by a subscription, the subscription will not appear in the dependent items list.

檢視 SharePoint 中的相依項目To view dependent items in SharePoint

  1. 開啟包含 .rsds 檔案的文件庫。Open the library that contains the .rsds file.

  2. 指向共用資料來源。Point to the shared data source.

  3. 按一下即可顯示向下箭頭,然後選取 [檢視相依項目]。Click to display a down arrow, and select View Dependent Items.

    若為報表模型,相依項目的清單就會顯示在報表產生器中建立的報表。For report models, the list of dependent items shows the reports that were created in Report Builder. 若為共用資料來源,相依項目清單可能會同時包括報表和報表模型。For shared data sources, the dependent items list can include both reports and report models.

另請參閱See Also

資料連接、資料來源及連接字串 (報表產生器和 SSRS) Data Connections, Data Sources, and Connection Strings (Report Builder and SSRS)
管理報表資料來源 Manage Report Data Sources
設定編頁報表的資料來源屬性Configure Data Source Properties for a Paginated Report