Sql Server 2005, Reporting Services, Data Driven Subscriptions

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.
Fraser_AdminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

YurichCommented:
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
Fraser_AdminAuthor Commented:
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
Fraser_AdminAuthor Commented:
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

YurichCommented:
You're right... that's what it meant to be, you must have an Enterprise edition
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
pumaken68Commented:
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
pumaken68Commented:
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
Fraser_AdminAuthor Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.