Solved

Sql Server 2005, Reporting Services, Data Driven Subscriptions

Posted on 2007-03-17
7
396 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

622 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