April 4, 2013 at 7:01 am
Hi
I have a simple SSRS report with list of users and one of the fields has their email address.
I want to email the rpeort to the email addresses in this field, can i build a subscription depending on the entries in a field?
Thanks in advance
April 4, 2013 at 8:37 am
Yes, its called a data driven subscription.
http://msdn.microsoft.com/en-us/library/ms169673.aspx
I believe you need Enterprise Edition for this.
April 4, 2013 at 8:41 am
We had a need to have data driven report subscriptions. The only way I found to use the existing subscription functionality was to create a subscription for each potential person (which creates a job for each subscription), and then write a procedure to parse the data and execute the appropriate subscription job.
The maintenance of that would be a nightmare, so instead I ended up creating an SSIS package that pulled in the data (emails and schedules), built the URL for the Reporting Services report to be run including all of the parameters, then used some .Net code to call the report URL and write the returned data to a file, then emailed the file to the appropriate person.
It worked, but it seems like there should be some way to do something like this within Reporting Services. If you find a way please let me know!
April 4, 2013 at 8:45 am
Chrissy321 (4/4/2013)
Yes, its called a data driven subscription.http://msdn.microsoft.com/en-us/library/ms169673.aspx
I believe you need Enterprise Edition for this.
Fantastic, thanks Chrissy321! Where were you 6 months ago? :-P:-D
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply