May 12, 2005 at 9:22 am
I have SQL Report Server set up on my server. I have the subscriptions working (ie can email out scheduled reports) and am trying to use the Adventure Works database (parameter report) to create the Data-Driven Subscription.
I have followed the instructions by Micorosoft, created a database called Subscriptions, have credentials stored in the server, etc. I am logged with adminstrative rights
I can add a new subscription to the report but never see the button under subscription for data driven subscriptions so cannot create a data base subscription. Does anyone know what I am missing?
Thanks
Karen
May 12, 2005 at 10:21 am
Possibly you've installed Standard Edition? Only Enterprise Edition supports data driven queries.
Steve.
May 12, 2005 at 2:19 pm
I think you may be correct,.I have the "free" edition..will have to look into the enterprise edition
Thank you!
May 23, 2006 at 6:03 pm
Karen,
I've come up with a way to do this in standard. Its rough and I plan on tidying it up, but we're using it at my company and it works.
You can see it here -->http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1733
Rate it if you like it...
hope this helps,
Jason
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgViewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply