Solved

Sql Server 2005, Reporting Services, Data Driven Subscriptions

Posted on 2007-03-17
7
392 Views
Last Modified: 2012-06-27
Do you need to have enterprise edition of sql server 2005 in order to generate data driven subscriptions.  Or does anyone have a work around using standard edition that will allow queries returning 0 records to not email a 0 record report.
0
Comment
Question by:Fraser_Admin
  • 3
  • 2
  • 2
7 Comments
 
LVL 21

Expert Comment

by:Yurich
ID: 18744725
It should be fine with a standard edition:
http://msdn2.microsoft.com/en-us/library/aa179341(SQL.80).aspx

and here is a tutorial:
http://msdn2.microsoft.com/en-us/library/ms169673.aspx

Cheers,
Yurich
0
 

Author Comment

by:Fraser_Admin
ID: 18744981
why do i not see the option to create a data driven subscription?  what do I need to setup in order to have this option?
0
 

Author Comment

by:Fraser_Admin
ID: 18744994
This is a quote from the site you just sent me.....Doesn't look like I'm able to do this???

Standard Edition
Standard Edition is designed for a production server in a single-computer configuration, which centralizes server-side report processing, storage, and tools. Choose Standard Edition if you do not need to support a large number of users, and do not need to support the dynamic distribution of reports to many users. The following features are not part of the Standard Edition:

Report Server Web farm deployment
Security extensions, including support for custom or forms-based authentication
Data-driven subscriptions
Support for more than 2 processors
0
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
LVL 21

Accepted Solution

by:
Yurich earned 500 total points
ID: 18745374
You're right... that's what it meant to be, you must have an Enterprise edition
0
 

Expert Comment

by:pumaken68
ID: 18747483
I'm facing the same issue. I want to preload the cache in RS 2005(http://msdn2.microsoft.com/en-us/library/ms155876.aspx), which requires data-driven subscription but that's only available to SQL server 2005 enterprise edition. Does anyone know a walk around solution to this?

I found an article: http://www.codeproject.com/database/DataDrivenSubscriptions.asp but didn't quite get it because it's for RS 2000. Let me know if you get it working.
0
 

Expert Comment

by:pumaken68
ID: 18747747
Anyone who provides a solution for this question could get my 500 points as well at
http://www.experts-exchange.com/Database/Reporting_/Q_22457812.html
0
 

Author Comment

by:Fraser_Admin
ID: 18770670
I just ended up creating an sql server job that executes a stored procedure which creates an html page with the information and then emails it.  I just formatted it to be like a report.  Then inside the sp i can say if there isn't any records don't email.  Don't know if this help you.  It got me by for now.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question