I would like to know if it is possible to add a custom delivery extension(?) in SSRS that will enable me to force a value into the "TO" address for particular subscriptions?

Big picture: I am exploring ways to schedule reports that would only permit them to be sent to a specific email address.

EDIT: Somewhat related, I would also like to know if I can create a second e-mail delivery extension without having do any programming. i.e. I would copy the extension details from RSReportServer.config for the "Report Server Email", give it a new name, and change a single configuration value.

SECOND EDIT: In the hopes of getting some additional input and ideas, the big BIG picture is I want to create a method to create an SSRS subscription that would guarantee the recipient is a particular e-mail address. This method should be usable by all users, but even knowing how to let one user might be workable. Subscriptions to other e-mail addresses must still be permitted.


What version of SQL Server/SSRS are you using? If you have SQL Server Enterprise then you can use Data Driven Subscriptions which allows you to use a query to define the various subscription delivery parameters such as To, CC, Subject etc.

| improve this answer | |
  • thanks for the feedback but I am looking at add a new custom delivery extension to co-exist with the existing type of subscriptions. I need to force the email to a specific mailbox; relying upon the report subscriber to create a data-drive subscription would not be an option. – JHFB Jun 7 '12 at 11:37
  • @JHFB as the admin you can go in and specify the location of "to" - but this seems to not be what you're seeking. i'm having a hard time understanding exactly what it is you're asking for. it's probably the fog in my brain that's clouding things. – swasheck Jul 6 '12 at 16:23

Struggling to understand the concept of this. Why would I as a user wish to subscribe to a report and have the subscription go to myself as well as a specific mailbox which I wouldn't know who or what the purpose is for this?

Is this to provide a copy of the delivered subscription content to a generic mailbox for monitoring purposes?

UPDATE: I think you would need to create a custom asp page to deal with subscriptions rather than the report manager in order to achieve this. You could limit what values the user can specify when setting up a subscription.

Alternatively you could use a stored procedure/trigger to change the values of the to, CC, or bcc fields to your default mailbox after the subscription has been setup, though this may be confusing for users.

Even if this was achieved I presume all users will require access to this generic mailbox? What would prevent them from forwarding the email to another mailbox or saving the attachment to allow it to be transferred.

| improve this answer | |
  • In this case, users would only be permitted to set up a subscription that was sent to a specific mailbox - they could not receive the content themselves. I was (and I guess still am) investigating a way that I could guarantee management that only one email address was receiving subscriptions. – JHFB Oct 26 '12 at 19:28
  • Please see my updated answer. – mheptinstall Oct 28 '12 at 16:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.