sql - Data Driven Subscriptions SSRS Standard Edition 2008

Question

I'm fairly new to MSSQL and SSRS.

I'm trying to create a data driven subscription in MSSQL 2008 Standard SSRS that does the following.

Email the results of the report to a email address found within the report. Run Daily

For Example:

Select full_name, email_address from users where (full_name = 'Mark Price')

This would use the email_address column to figure out who to email, This must also work for multiple results with multiple email address's.

The way I'm thinking of doing this is making a subscription to run the query, if no result is found then nothing happens. But if a result is found then the report changes the row in Subscriptions table to run the report again in the next minute or so with the correct email information found in the results. Is this a silly idea or not?

I've found a couple blog posts claiming this works but i couldn't understand their code enough to know what it does.

So, Any suggestions on how to go about this or if you can suggest something already out there on the internet with a brief description?

Answer 1

This takes me back to my old job where I wrote a solution to a problem using data-driven subscriptions on our SQL Server 2005 Enterprise development box and then discovered to my dismay that our customer only had Standard.

I bookmarked this post at the time and it looked very promising, but I ended up moving jobs before I had a chance to implement it.

Of course, it is targeted at 2005, but one of the comments seems to suggest it works in 2008 as well.