January 30, 2008 at 2:49 am
Hello folks,
Does anybody have experience with e-mail distribution using Data Driven Subscriptions?
I want to build the following:
I have a table with names and e-mail addresses of people in my data warehouse. This table changes over time, more people will be added and data (for example e-mail addresses) can change.
I made 1 report that I want to mail to all the people in the table. This report contains 1 parameter; the e-mail address of a person.
So basically it’s quite simple: I want to e-mail all the people in the table a personalized (by the parameter) report each month.
Can anybody tell me how I can achieve this with SSRS 2005? I know how to make a data driven subscription but how can I make one pending on the data in a table?
Any help would be appreciated. I will write a blog about this when I've done it so your input will not get lost.
Jorg
---------------------------------------------------
My Microsoft Business Intelligence blog: http://sqlblogcasts.com/blogs/jorg/
January 30, 2008 at 4:14 am
First, your report should not have a parameter for the email it is being sent to unless you want to actually display the email address in the report.
As far as using data-driven subscriptions, the steps in setting one up ask you for a query that returns your list of email addresses, then a subsequent step asks you which column from that data set will be the email address. If you are looking for something mysterious and complicated, you may be overlooking how simple it really is.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply