We currently have a reporting model that supports running reports on demand and/or on a schedule. Our reporting model also supports email and printer distribution.
I have been asked to explore leveraging SSRS for our reporting model moving forward. How can I programmatically create a data driven subscription?
Hope this is what you're looking for
http://www.sqlservercurry.com/2009/07/programmatically-create-data-driven.html
Did you mean programmatically in C# or TSQL? In TSQL, you can create a stored procedure (defining the biz logic) and have it return the columns that the "Data Driven Subscription" wizard would expect.
If you meant C# then visakh16 appears to have the solution.
