#SharePoint Integration Mode and no Data Driven Subscriptions #SP2013 #SP2010 #SSRS
Just come back after the New Year and was posed with an interesting problem.
SharePoint 2010, SSRS in integration mode but under the manage subscriptions link within a report, the Add Data Driven Subscription button was missing from the screen.
So after some googling / binging around, I found that the answer was because we were using SQL Server 2008 Standard and Data Driver Subscriptions require the Enterprise version of SQL Server.
Anyway, just a quick post in case I forget in future. Useful links below:
- SSRS Feature Support – Integration Mode: http://msdn.microsoft.com/en-us/library/bb326290(v=sql.100).aspx
- How to use Data Driven Subscriptions within SharePoint: http://blogs.devhorizon.com/reza/2008/10/26/ssrsdata-driven-subscriptions-in-integrated-mode-part-1/
- Required versions for Data Driven Subscription support: http://msdn.microsoft.com/en-us/library/ms159150(v=sql.100).aspx
Although in this scenario I am talking about SQL Server 2008, the same is true of SQL Server 2008 R2. In SQL Server 2012, Enterprise or Business Intelligence editions are required: