goodmanro
asked on
Data-Driven Subscriptions for SSRS Reports with SQL 2008 Standard Edition
I have a need to create a scheduled report via email (2x weekly). This report would be received by a dynamic list of individuals that would be published in a SQL table. Ideally, I would do this in Report Manager and use data driven subscriptions. However, I am on SQL Server 2008 Standard Edition which doesn't enable this functionality. Does anyone have a recommendation, or a script that may offer similar functionality?
You can create a .net application that make use of the rdl and send mail to the list of users through db_mail using the list you have in your table stored.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Using SQL Server Enterprise version is the easiest option. SThaya offers a nice work-around for SQL Server Standard above.