Reporting Services 中User订阅报表问题 RRS feed

  • 问题

  • 我在测试Reporting Services时,给User管理单独的订阅     每个用户均可创建、查看、修改和删除所拥有的订阅。”的权限。在该User创建个人订阅的时候,选择邮件的方式时,收件人默认是User的名字,并且不能修改,但是User却无法收到邮件。我想问一下从User Name解析Email的具体过程以及这种问题的解决方式。

    2008年6月12日 6:41


  • 可以接收RS的邮件服务的用户, 是从能够访问所订阅的报表的数据源的用户列表中解析得到的,也就是说订阅用户必须有权限访问这些报表。



    1. RS的mail配置问题:打开RS配置管理工具,进入邮件设置页,检查Mail发送者,SMTP服务器的设置是否正确。
    2. 报表数据源的设置:以管理员身份登陆报表管理页面(不是配置管理工具页面)--〉报表属性--〉数据源,检查你配置的user是否是在允许访问该数据源的用户范围内。


    2008年6月12日 10:14


  • E-Mail Delivery in Reporting Services

    Reporting Services includes an e-mail delivery extension that provides a way to e-mail a report to individual users or groups. The e-mail delivery extension is configured through the Reporting Services Configuration tool and by editing the Reporting 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. For more information about subscriptions, see Creating, Modifying, and Deleting Subscriptions.

    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 specifies the name of the report.
      @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.
      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. All other rendering formats (CSV, PDF, and so on) deliver reports as attachments. You can disable this functionality in the RSReportServer configuration file.
      Reporting 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 will not be delivered. 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 will include a hyperlink to the report. For more information, see How to: Subscribe to a Report (Report Manager).

    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 additional ways to route a report to more subscribers. The availability of e-mail alias fields is defined through the RSReportServer configuration file settings.

    If you are distributing reports within an intranet and you are using an SMTP gateway to a Microsoft 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 additional 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.

    The report server connects with an e-mail server using a standard connection. It does not use communication that has been encrypted using Secure Sockets Layer (SSL). The e-mail server must be a remote or local Simple Mail Transport Protocol (SMTP) server located on the same network as the report server. An RSReportServer configuration setting specifies the SMTP server. For more information, see Configuring a Report Server for E-Mail Delivery.


    Hope this helps.

    2008年6月12日 6:56
  • 可以接收RS的邮件服务的用户, 是从能够访问所订阅的报表的数据源的用户列表中解析得到的,也就是说订阅用户必须有权限访问这些报表。



    1. RS的mail配置问题:打开RS配置管理工具,进入邮件设置页,检查Mail发送者,SMTP服务器的设置是否正确。
    2. 报表数据源的设置:以管理员身份登陆报表管理页面(不是配置管理工具页面)--〉报表属性--〉数据源,检查你配置的user是否是在允许访问该数据源的用户范围内。


    2008年6月12日 10:14