September 25, 2009 at 3:24 pm
I have a parameterized report. I need to create a subscription for 20 different locations by overriding the default parameter. I would like to use one shared schedule for all subscriptions. The drop down appears in the subscription form, but I haven't been able to find where you can create the shared schedule in WSS 3.0 site. I can create a custom schedule for each subscription that work fine
September 25, 2009 at 5:39 pm
If you are not running SQL Server Enterprise edition then you need to write extra code or use existing solution, so post back with SQL Server edition so i can help.
Kind regards,
Gift Peddie
September 28, 2009 at 8:52 am
Sorry about that,
Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
September 28, 2009 at 9:10 am
toll (9/28/2009)
Sorry about that,Microsoft SQL Server 2005 - 9.00.3054.00 (X64) Mar 23 2007 18:41:50 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
In SQL Server standard you need to print out the article in the link below and read it then modify the code and use it because Microsoft did not provide data driven subscription for the standard edition. I have not looked for WSS solution for the problem.
http://www.sqlservercentral.com/articles/Development/datadrivensubscriptions/2432/
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply