{"id":761,"date":"2008-10-26T20:28:45","date_gmt":"2008-10-27T01:28:45","guid":{"rendered":"http:\/\/blogs.devhorizon.com\/reza\/?p=761"},"modified":"2008-10-29T14:44:32","modified_gmt":"2008-10-29T19:44:32","slug":"ssrsdata-driven-subscriptions-in-integrated-mode-part-1","status":"publish","type":"post","link":"https:\/\/blogs.devhorizon.com\/reza\/2008\/10\/26\/ssrsdata-driven-subscriptions-in-integrated-mode-part-1\/","title":{"rendered":"SSRS:Data Driven Subscriptions in Integrated mode (Part 1)"},"content":{"rendered":"

The thing is, if you read SQL Server 2008 books online (For example here<\/a> or here<\/a>) , it is explicitly mentioned that Data-driven subscriptions are not supported when the report server is configured for SharePoint integrated mode!\u00a0 I could have sworn that I heard several times from SSRS top subject matters that they have added this new functionality to the SSRS 2008. Plus looking at the proxy endpoint tells me that the functionality is there, but <rant>like a lot of other things in the Integrated mode (and I’m talking about SSRS 2008 not 2005 SP2), there are a few non-MS people who have gone ahead and partially demonstrated how to implement stuff! All I see is a marketing *LIST* of all the new goodies ,but\u00a0 not even a single Web cast or How-To with the focus on the integration<\/rant> lovely! eh?<\/p>\n

So one million dollar question is : Is Data Driven Subscriptions part of SSRS 2008 when it is configured in integrated mode? Answer is Yes! It is fully supported.<\/p>\n

Before I walk you through how to set this up in SharePoint (mostly covered in Part 2<\/a>) , I would like to give you\u00a0 a brief tour of what the data driven subscription concept is and show you some preparatory steps that you need to take before you touch the SharePoint equivalent feature sets. Okay, let’s get the ball rolling here:<\/p>\n

Generally speaking in SSRS , subscriptions are an alternative way of delivering reports to people in a very dynamic and automated manner.The objective is minimizing On-demand access to the report server; therefore reducing the traffic and boosting the performance.\u00a0 It is all about targeting different information at different audiences , all done in a data driven fashion and asynchronously (can’t u tell that I am a developer?! \ud83d\ude09 )\u00a0 delivered to them. Subscriptions are processed on the report server and are distributed through delivery extensions (another important concept in SSRS) that are deployed on the server. Two very important delivery extensions in SharePoint are:<\/p>\n