Reporting Services 中的電子郵件傳遞E-Mail Delivery in Reporting Services

SQL Server Reporting ServicesReporting Services 包含了電子郵件傳遞延伸模組,可讓您透過電子郵件傳送報表給個別使用者或群組。SQL Server Reporting ServicesReporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups. 您可以透過 Reporting Services 組態管理員並藉由編輯 Reporting ServicesReporting Services 組態檔,設定電子郵件傳遞延伸模組。The e-mail delivery extension is configured through the Reporting Services Configuration Manager and by editing the Reporting ServicesReporting Services configuration files.

若要透過電子郵件散發或接收報表,您可以定義標準訂閱或資料驅動訂閱。To distribute or receive a report by e-mail, you define either a standard subscription or a data-driven subscription. 您一次只能訂閱或散發一個報表。You can subscribe to or distribute only one report at a time. 您無法建立在單一電子郵件訊息中傳遞多個報表的訂閱。You cannot create a subscription that delivers multiple reports in a single e-mail message. 如需有關訂用帳戶的詳細資訊,請參閱建立、 修改和刪除標準訂用帳戶(原生模式的 Reporting Services)For more information about subscriptions, see Create, Modify, and Delete Standard Subscriptions (Reporting Services in Native Mode).

適用於:Applies to: Reporting ServicesReporting Services SharePoint 模式|SharePoint 2010 和 SharePoint 2013適用於:Applies to: Reporting ServicesReporting Services SharePoint mode | SharePoint 2010 and SharePoint 2013

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

電子郵件傳遞選項E-Mail Delivery Options

報表伺服器電子郵件傳遞可以利用下列方式傳遞報表:Report server e-mail delivery can deliver reports in the following ways:

  • 傳送通知和超連結到產生的報表。Send a notification and a hyperlink to the generated report.

  • 在電子郵件訊息的 [主旨:] 傳送通知。Send a notification in the Subject: line of an e-mail message. 依預設,訂閱定義中的 [主旨:] 包含下列變數,處理訂閱時,會以報表特定資訊取代這些變數:By default, the Subject: line in the subscription definition includes the following variables that are replaced by report-specific information when the subscription is processed:

    @ReportName** 指定報表的名稱。@ReportName** specifies the name of the report.

    @ExecutionTime** 指定報表執行的時間。@ExecutionTime** specifies when the report was executed.

    您可以將這些變數與靜態文字結合,或者修改每個訂閱 [主旨:] 中的文字。You can combine these variables with static text or modify the text in the Subject: line for each subscription.

  • 傳送內嵌的或附加的報表。Send an embedded or attached report. 轉譯格式和瀏覽器會決定是否要內嵌或附加報表。The rendering format and browser determine whether the report is embedded or attached.

    如果您的瀏覽器支援 HTML 4.0 與 MHTML,而且您選擇網頁封存轉譯格式,則報表會內嵌為訊息的一部分。If your browser supports HTML 4.0 and MHTML, and you choose the Web archive rendering format, the report is embedded as part of the message. 所有其他轉譯格式 (CSV、PDF 等等) 均以附加檔案傳遞報表。All other rendering formats (CSV, PDF, and so on) deliver reports as attachments. 您可以在 RSReportServer 組態檔中停用此功能。You can disable this functionality in the RSReportServer configuration file.

    Reporting ServicesReporting Services 在傳送報表之前,不會檢查附加檔案或訊息的大小。does not check the size of the attachment or message before sending the report. 如果附加檔案或訊息超過郵件伺服器所允許的上限,將不會傳遞報表。If the attachment or message exceeds the maximum limit allowed by your mail server, the report is not delivered. 如果是大型報表,請選擇其他傳遞選項之一 (例如 URL 或通知)。Choose one of the other delivery options (such as URL or notification) if for large reports.

您可以設定傳遞選項,來決定建立訂閱時如何傳遞報表。You set delivery options that determine how a report is delivered when you create the subscription. 例如,您若是在訂閱中選取 [包含連結] ,則電子郵件訊息包含連結到報表的超連結。For example, if you select Include Link in the subscription, the e-mail message includes a hyperlink to the report.

以角色為基礎的電子郵件設定Role-based E-Mail Settings

您訂閱報表時所使用的電子郵件傳遞設定,會依您的角色包含的是「管理個別訂閱」工作或「管理所有訂閱」工作而異。When you subscribe to a report, the e-mail delivery settings you work with vary depending on whether your role includes the "Manage individual subscriptions" task or the "Manage all subscriptions" task.

工作Task 可用的設定Available settings
管理個別訂閱Manage individual subscriptions 顯示讓使用者可自動化並傳遞報表給自己的欄位。Shows fields that enable a user to automate and deliver a report to himself or herself. 在此模式下,接受電子郵件別名的欄位無法使用。In this mode, fields that accept e-mail aliases are not available.
管理所有訂閱Manage all subscriptions 顯示支援全域散發的欄位,包括 [收件者:]、[副本:]、[密件副本:] 和 [回覆至:] 欄位,提供更多方式傳送報表給更多訂閱者。Shows fields that support wider distribution, including To:, Cc:, Bcc:, and Reply-To: fields, providing more ways to route a report to more subscribers. 電子郵件別名欄位的可用性是透過 RSReportServer 組態檔設定定義。The availability of e-mail alias fields is defined through the RSReportServer configuration file settings.

在訂閱中指定電子郵件位址Specifying E-Mail Addresses in a Subscription

如果您是在內部網路散發報表,而且使用的是通往 MicrosoftMicrosoft Exchange 伺服器的 SMTP 閘道,請輸入電子郵件別名 (就像您傳送電子郵件給同事一樣)。If you are distributing reports within an intranet and you are using an SMTP gateway to a MicrosoftMicrosoft Exchange server, type the e-mail alias (as if you were sending e-mail to a coworker). 若要傳遞到外部電子郵件帳戶,請輸入完整電子郵件地址。If delivery is to an external e-mail account, type the full e-mail address. 如果指定更多電子郵件地址以加入其他人到訂閱中,訂閱者會取得此訂閱所產生的報表完整副本。If you specify more e-mail addresses to add others to your subscription, subscribers get an exact copy of the report that is produced from this subscription.

報表伺服器不會驗證電子郵件地址,或從電子郵件伺服器取得電子郵件地址。The report server does not validate e-mail addresses or obtain e-mail addresses from an e-mail server. 您必須事先知道要使用的電子郵件地址。You must know in advance which e-mail addresses you want to use. 依預設,您可以利用電子郵件傳送報表給組織內外任何有效的電子郵件帳戶。By default, you can e-mail reports to any valid e-mail account within or outside of your organization. 但是,可以使用組態設定,將電子郵件傳遞至限制在您依名稱識別的郵件伺服器主機。Configuration settings can be used, however, to restrict e-mail delivery to mail server hosts that you identify by name. 如果您想要支援電子郵件傳遞給非組織成員的人,則可以指定其他主機。You can specify additional hosts if you want to support e-mail delivery to people that are not members of your organization.

用來傳遞報表的電子郵件訊息,必須從電子郵件伺服器上所定義的電子郵件帳戶傳送。The e-mail message used to deliver the report must be sent from an e-mail account that is defined on the e-mail server. 組態設定會指定電子郵件帳戶。A configuration setting specifies the e-mail account. 電子郵件帳戶是供所有藉由電子郵件傳遞延伸模組傳遞之報表所使用的;您無法指定多個帳戶或對個別報表指定不同帳戶。The e-mail account is used for all reports delivered by the e-mail delivery extension; you cannot specify multiple accounts or vary the account for individual reports.

電子郵件伺服器組態E-Mail Server Configuration

報表伺服器會透過標準連線來與電子郵件伺服器連接。The report server connects with an e-mail server through a standard connection. 並未使用以安全通訊端層 (SSL) 加密的通訊。It does not use communication that has been encrypted using Secure Sockets Layer (SSL). 電子郵件伺服器必須是與報表伺服器在相同網路中的遠端或本機 Simple Mail Transport Protocol (SMTP) 伺服器。The e-mail server must be a remote or local Simple Mail Transport Protocol (SMTP) server on the same network as the report server.

如需如何設定原生模式報表伺服器的詳細資訊,請參閱下列內容:For information on how to configure a native mode report server, see the following:

如需如何設定 SharePoint 模式報表伺服器的詳細資訊,請參閱下列內容:For information on how to configure a SharePoint mode report server, see the following:

另請參閱See Also

工作和權限 Tasks and Permissions
訂閱與傳遞 (Reporting Services) Subscriptions and Delivery (Reporting Services)
資料驅動訂閱 Data-Driven Subscriptions
角色指派Role Assignments