November 29, 2017 at 6:10 pm
Is there a way to automatically pull in Email addresses into SSRS instead of manually entering them in for each subscription? IF not, does anyone know of another tool that will allow custom reporting and charting along with the ability to automate email addresses from databases?
Thanks in advance!
November 30, 2017 at 1:52 am
I assume you mean that you want the recipient to be dynamic based on something? This is achievable. with SSRS.
Don't quote me on it, but I believe it's a feature of Data Derived Subscriptions, however, that's only available on on Enterprise edition. You can, however, achieve similar results using your own SQL to do the task for you; I use this technique to change the parameters, and save locations dynamically for files.
I don't have dynamic mail recipients, but I doubt it would be very different. There is also an article on it here (not my solution) which might help you: http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/163119/?utm_source=SSC&utm_medium=pubemail
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 30, 2017 at 9:46 am
Very cool!! Thank you for the link. I'll study this and see what i can do to set this up. You're awesome!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply