通过电子邮件发送MS Reporting Services 2005报告，就像从特定地址发送一样

We have various reporting services reports which are scheduled to automatically generate reports and email them to a distribution list. This works really well but they appear to come from [e-mail].

我们提供各种报告服务报告,这些报告计划自动生成报告并通过电子邮件发送到分发列表。这非常有效,但它们似乎来自[e-mail]。

This is all well and good but the PHB would like them to look like they are coming from [e-mail]. We've got a group set up so Exchange lets us (those within OurGroup) send messages from Outlook using OurGroup in the From address, but I'm struggling to find how to configure Reporting Services to do this.

这一切都很好,但PHB希望他们看起来像是来自[e-mail]。我们已经设置了一个组,因此Exchange允许我们(OurGroup内的那些人)使用From地址中的OurGroup从Outlook发送邮件,但我很难找到如何配置Reporting Services来执行此操作。

Is it a server wide configuration option? Is it a user access profile option? Could we do it programatically by attaching to the RS Server using an app (many of the reports are triggered by code already).

它是服务器范围的配置选项吗?它是用户访问配置文件选项吗?我们可以通过使用应用程序连接到RS服务器来编程地执行此操作(许多报告已由代码触发)。

Edit: We share the server with other groups - so it has to be for a subset or on a report-by-report basis. (It's RS'05 if it makes a difference, although we're on the path to upgrading to '08.)

编辑:我们与其他组共享服务器 - 因此它必须是子集或逐个报告。 (如果它有所作为,它是RS'05,尽管我们正在升级到'08。)

3 个解决方案

#1

Sorry, you can't.

对不起,你不能。

Because it use SMTP, you are limited to the protocol. The setting are defined in the .config files and are not configurable at run time or in the app or in a report/subscription.

因为它使用SMTP,所以您仅限于协议。该设置在.config文件中定义,在运行时或应用程序或报表/订阅中不可配置。

Outlook uses MAPI which allows "From" to be specified.

Outlook使用MAPI,允许指定“从”。

Now, there are ugly workarounds :-)

现在,有一些丑陋的变通办法:-)

1. If you send the reports to a mailbox, then you can use rules to forward and change the email. However, the mailbox must be associated with a login that you can log into and configure the rules. Otherwsie, you'll need Outlook running to apply rules if you simply connect to the mailbox.

   如果将报告发送到邮箱,则可以使用规则转发和更改电子邮件。但是,邮箱必须与您可以登录并配置规则的登录相关联。另外,如果您只是连接到邮箱,则需要Outlook运行才能应用规则。

2. Install RS multiple times and configure the "From" email differently per install. In this case "FROM" is defined in the config files.

   多次安装RS并按安装不同方式配置“发件人”电子邮件。在这种情况下,“FROM”在配置文件中定义。

3. Send email to a service that monitors the mailbox to do your forwarding

   将电子邮件发送到监视邮箱的服务以进行转发

Option 3 is obviously the neatest but has most investment.

选项3显然是最好的,但投资最多。

#2

You can configure the sender e-mail address using the Reporting Services Configuration Manager (available under "Configuration" in the SQL Server 2005 start menu item). On the left-side pane, click the "Email Settings" header, and specify the sender address.

您可以使用Reporting Services配置管理器(在SQL Server 2005开始菜单项中的“配置”下提供)配置发件人电子邮件地址。在左侧窗格中,单击“电子邮件设置”标题,然后指定发件人地址。

This is the address that will appear on ALL reports generated on the server you are configuring. I don't believe there is a way to specify sender addresses on a report level.

这是将在您正在配置的服务器上生成的所有报告上显示的地址。我不相信有一种方法可以在报告级别指定发件人地址。

HTH.

#3

Are you using a data-driven subscription, or just a simple subscription type in RS to distribute your report?

您是使用数据驱动的订阅,还是使用RS中的简单订阅类型来分发报告?

I believe with a data-driven subscription, you can provide a custom table with information that can be used by the subscription engine to specify properties of the subscription, including the parameters for a report, recipient list, format type, etc. It lets you specify the TO/FROM/SUBJECT, etc for the email communication based on the data found in your custom table. Check it out and let us know if that works out for you.

我相信通过数据驱动的订阅,您可以提供一个自定义表,其中包含订阅引擎可以使用的信息,以指定订阅的属性,包括报表的参数,收件人列表,格式类型等。它可以让您根据自定义表中的数据为电子邮件通信指定TO / FROM / SUBJECT等。检查一下,如果有效,请告诉我们。

cheers.