Reporting Services 中的檔案共用傳遞File Share Delivery in Reporting Services

SQL Server Reporting ServicesReporting Services 包括檔案共用傳遞延伸模組,讓您可以傳遞報表到資料夾。SQL Server Reporting ServicesReporting Services includes a file share delivery extension so that you can deliver a report to a folder. 依預設,可以使用檔案共用傳遞延伸模組,且不需額外的組態。The file share delivery extension is available by default and requires no additional configuration. 若要順利完成檔案傳遞,您必須設定共用資料夾的寫入權限。In order for file delivery to succeed, you must set write access permissions on the shared folder. 需要寫入者權限之帳戶可以是訂用帳戶中所設定認證或針對報表伺服器所設定的檔案共用帳戶The account that requires writer permissions can either be credentials configured in the subscription or a File share account configured for the report server. 如需檔案共用帳戶的詳細資訊,請參閱 訂閱設定與檔案共用帳戶 (組態管理員)For more information on the file share account, see Subscription Settings and a File Share Account (Configuration Manager). 此外,需要存取報表的使用者必須擁有共用資料夾的讀取權限。In addition, users who require access to the reports must have read permissions on the shared folder.

若要散發報表到檔案共用,您必須定義標準訂閱或資料驅動訂閱。To distribute a report to a file share, you define either a standard subscription or a data-driven subscription. 若要了解如何在資料驅動訂閱中使用檔案共用傳遞,請參閱建立資料驅動訂閱 (SSRS 教學課程)To learn how to use file share delivery in a data-driven subscription, see Create a Data-Driven Subscription (SSRS Tutorial). 此外,執行遠端檔案共用訂閱的帳戶需要在 Reporting ServicesReporting Services 電腦上進行本機登入的權限。Additionally, the account that runs remote file share subscriptions requires rights to log on locally on the Reporting ServicesReporting Services computer.

適用於:Applies to: Reporting ServicesReporting Services 原生模式 | Reporting ServicesReporting Services SharePoint 模式適用於:Applies to: Reporting ServicesReporting Services Native mode | Reporting ServicesReporting Services SharePoint mode

本主題內容:In this topic:

傳遞給共用資料夾之報表的特性Characteristics reports delivered to shared folders

  • 傳遞給共用資料夾的報表屬於靜態檔案,這和報表伺服器所主控及管理的報表不同。Unlike reports that are hosted and managed by a report server, reports that are delivered to a shared folder are static files.

  • 為報表定義的互動式功能 不適用於 以檔案形式儲存在檔案系統中的報表。Interactive features that are defined for the report do not work for reports that are stored as files on the file system. 互動式功能是以靜態元素來表示。Interaction features are represented as static elements. 例如,如果您傳遞矩陣報表,所產生的檔案會顯示報表的最上層檢視;您無法展開資料列和資料行來檢視支援的資料。For example, if you deliver a matrix report, the resulting file shows the top-level view of the report; you cannot expand rows and columns to view supporting data.

  • 如果報表包括圖表,則使用預設呈現方式。If the report includes charts, the default presentation is used. 如果報表連結到其他報表,則連結會轉譯成靜態文字。If the report links through to another report, the link is rendered as static text.

  • 如果您想要在傳遞的報表中保留互動式功能,請改用電子郵件傳遞。If you want to retain interactive features in a delivered report, use e-mail delivery instead. 電子郵件會包含報表伺服器上報表的連結,而且使用者可以使用互動式功能。The e-mail contains a link to the report on the report server and users can use the interactive features. 如需詳細資訊,請參閱 Reporting Services 中的電子郵件傳遞For more information, see E-Mail Delivery in Reporting Services.

目標資料夾Target folders

定義使用檔案共用傳遞的訂閱時,必須指定現有的資料夾做為目標資料夾。When defining a subscription that uses file share delivery, you must specify an existing folder as the target folder. 報表伺服器不會在檔案系統中建立資料夾。The report server does not create folders on the file system. 您指定的資料夾必須可以透過網路連接來存取。The folder that you specify must be accessible over a network connection.

確認要 檢視 共用資料夾中報表的使用者擁有讀取權限。Verify that users who will view the reports in the shared folder have Read permission.

在訂閱中指定目標資料夾時,請使用包含電腦網路名稱的統一命名慣例 (UNC) 格式。When specifying the target folder in a subscription, use Uniform Naming Convention (UNC) format that includes the computer's network name. 資料夾路徑中不要包含尾端的反斜線。Do not include trailing backslashes in the folder path. 下列範例說明 UNC 路徑:The following example illustrates a UNC path:

\\<servername>\reportarchive\operations\2014  

建立資料夾時,請考慮您需要的連接限制。When you create the folder, consider the connection limits you require. 雖然報表伺服器只需要兩個連接,但您必須包含足夠的連接來滿足其他想要開啟共用資料夾報表的使用者。The report server requires two connections, but you must include enough connections to accommodate additional users who want to open reports on the shared folder.

檔案格式File Formats

可以使用各種檔案格式 (例如 HTML、DOCX 和 Excel) 來轉譯報表。Reports can be rendered in a variety of file formats, such as HTML, DOCX, and Excel. 若要以特定的檔案格式儲存報表,請在建立您的訂閱時選取該轉譯格式。To save the report in a specific file format, select that rendering format when creating your subscription. 例如,選擇 [Excel] 會將報表儲存為 Microsoft ExcelMicrosoft Excel 檔案。For example, choosing Excel saves the report as a Microsoft ExcelMicrosoft Excel file. 雖然您可以選擇任何支援的轉譯格式,當轉譯檔案時有些格式會運作的比較好。Although you can choose from any supported rendering format, some formats work better than others when rendering to a file.

若為檔案共用傳遞,請選擇以單一檔案傳遞報表的格式,其中所有影像和相關內容會包括在報表內。For file share delivery, choose a format that delivers the report in a single file, where all images and related content are included in the report. 適當的格式包括網頁封存、PDF、TIFF 和 Excel。Suitable formats include Web archive, PDF, TIFF, and Excel. 請避免使用 HTML4.0。Avoid HTML4.0. 如果您的報表包含影像,HTML 4.0 格式就不會在檔案中包含這些影像。If your report includes images, the HTML 4.0 formats will not include them in the file.

檔案選項File Options

當您建立檔案共用訂閱時,可以設定檔案名稱的建立方式,以及檔案是否會覆寫報表的舊版本。When you create a file share subscription, you can configure how the file name is created and if the file overwrites previous versions of the report. 完整檔案名稱有三個部分:名稱、副檔名,以及附加至檔案以建立唯一檔案名稱的文字或數字A fully qualified file name has three parts: a name, an extension, and text or a number that is appended to the file to create a unique file name

檔案名稱 :預設檔案名稱是以來源報表名稱為基礎,但是您可以在訂閱中提供自訂名稱。File Name: The default file name is based on the source report name, but you can provide a custom name in the subscription. 副檔名為選擇性,但是如果您有指定副檔名,報表伺服器將會建立對應到轉譯格式的副檔名。The extension is optional, but if you specify it, the report server will create an extension that corresponds to the rendering format.

覆寫 :您可以指定覆寫選項,針對每一次報表傳遞重複使用相同的檔案名稱,或者建立新的檔案。Overwrite: You can specify overwrite options to reuse the same file name for each report delivery or to create a new file. 若要覆寫檔案,您必須使用相同的檔案名稱和副檔名。To overwrite the file, you must use the same file name and extension.

有一個替代方式可以在每一次傳遞中建立唯一的檔案,就是在檔案名稱中加入時間戳記。An alternative approach to creating unique files for every delivery is to include a timestamp in the file name. 若要這樣做,請將 @timestamp 變數加入檔案名稱 (例如 *CompanySales@timestamp* )。To do this, add the @timestamp variable to the file name (for example, *CompanySales@timestamp*). 使用這個方法時,會讓檔案名稱依照定義成為唯一的檔案名稱,所以絕對不會遭到覆寫。With this approach, the file name is unique by definition, so it will never be overwritten.

下圖是針對檔案共用傳遞所設定之訂用帳戶的檔案設定範例。The following image is an example of the settings for a subscription configured for file share delivery.

檔案共用訂用帳戶file share subscription

另請參閱See Also

建立及管理原生模式報表伺服器的訂閱 Create and Manage Subscriptions for Native Mode Report Servers
訂閱設定與檔案共用帳戶 (組態管理員)Subscription Settings and a File Share Account (Configuration Manager)