INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Setting up an SSRS Data Driven Subscription to email recipients using SharePoint

Setting up an SSRS Data Driven Subscription to email recipients using SharePoint

Setting up an SSRS Data Driven Subscription to email recipients using SharePoint

(OP)
thread1462-1621585: Running a report for mulitple clients
thread1462-1458983: Invoices/batch reports using Reporting Services?

I have been looking all over the web, trying to find a good example/tutorial about setting up Data Driven subscriptions for email recipients using SharePoint. Everything I find is about setting up subscriptions for delivery to shared folders.

I have successfully set up a DDS for a report that went to specified recipients. However, each of them got the same report, instead of receiving their own report specific to them. How is this set up? Do you have to use parameters to specify the recipient specific info? If so, how is this specified in the DDS?

If anyone knows of a good example/tutorial page, it would be greatly appreciated.
Microsoft's pages only go over the Shared Folder option. (https://msdn.microsoft.com/en-us/library/ms169972....)

RE: Setting up an SSRS Data Driven Subscription to email recipients using SharePoint

(OP)
Well, after looking all over for something and not finding what I needed. I just started doing some experimenting and figured it out.

Here is what I came up with.


The report must be set up with a Parameter which is used to identify the Grouping which the report will be limited to. In this case, the report will be limited to the specified sales person.

Put together a query which pulls a distinct list of recipients and email addresses. In this case it is from one data source and only includes three recipients. (It is not required to limit the list of recipients. In this case the WHERE clause can be eliminated to accommodate all sales persons in the data source)


SELECT DISTINCT

SalesPerson

, EmailAddress

FROM DataSource

WHERE SalesPerson IN ('mmouse', 'dduck', 'ppan')



Once the data connection information has been entered in the Data Definition screen, this query will need to be put into the Query box.

Select “Validate” when finished.

On the Parameters screen, Select the “Override report default value from database” radio button, and from the drop down, select the field which will give you the desired parameter. In this case, it would be SalesPerson.

On the Delivery Options screen, select “E-Mail as the Delivery Type”, and in the To field, Select the “Select a value from the database” radio button. Then from the drop down menu, select database filed which will provide the email addresses for the recipients of the reports. In this case it is EmailAddress.

Continue setting up the scheduled report with the desired formatting, delivery, and schedule options.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close