Solved

Sql Server 2005, Reporting Services, Data Driven Subscriptions

Posted on 2007-03-17
7
393 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
How to increase the row limit in Jasper Server.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

856 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