How do i create a datadriven subscription in SSRS 2008
Hi,
We were using SSRS 2005 and just converted all our reports to 2008 and we have 3 reports that use datadriven Subscription. In RS 2008 I dont see an option to create data driven subscription.
Can someone please give me the steps to create it... my SSRS version is
Microsoft SQL Server Reporting Services Version 10.50.1600.1
Thanks
karen
May 17th, 2011 2:18pm
You might not have the required rights, so you are probably not seeing that option.
For a step by step walk-through - http://msdn.microsoft.com/en-us/library/aa237461(v=sql.80).aspx
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 2:22pm
I added the content manager role under my user name but i still cannot see the data driven subscription?
Can you please tell me where should i set what in order to see it??
May 17th, 2011 3:12pm
Please note that datadriven
subscription is only available in Enterprise Edition. Are you sure you have Enterprise Edition?
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 3:17pm
i did a select @@version on that sql server and looks like i have a standard edition
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
May 17th, 2011 3:46pm
When i update to the enterprise edition would i have to upload my reports again to the server or will be automatically moved???
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2011 3:53pm
Assuming that you are talking about in-place upgrade, you don't need to upload the reports again and they'll contine to work.
May 17th, 2011 5:13pm