July 15, 2015 at 6:21 am
Hi
I have a set of results based on a query that displays a learner, their workplace assessor and both their email addresses.
I want to send a standard request email (using db_mail) to each learner's email address which specifies who their individual assessor is and their current employer. One per learner.
I then want to email each assessor and in this email detail their learners (and their employer details) that I have emailed the request too.
Does this make sense?
Thanks for any help offered.
Kind regards
Graham
July 15, 2015 at 6:29 am
If you have either the developer or enterprise edition of SQL Server, then you can use data driven subscriptions within SSRS. This allows you to specify a query to establish the recipients, and you can incorporate that query into the main data query and use that to customize the report content for each recipient, as the recipient can become a parameter to the report. That's probably the easiest way, but if you don't have enterprise edition, or aren't working on a personal project and thus don't have developer edition, it's not an option. Alternatively, you can use db mail, but I'm not going to be much help with that. There are other folks better suited to assist in that case.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply