Post reply

SQL Server Reports

  • May 12, 2005 at 9:22 am

    #362585

    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

    #558473

    Possibly you've installed Standard Edition?  Only Enterprise Edition supports data driven queries.

     

     

    Steve.

  • May 12, 2005 at 2:19 pm

    #558551

    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

    #639638

    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. Selburg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply