Report that returns no records.

Posted on 2011-09-19
Medium Priority
Last Modified: 2012-05-12
I have a report that executes on a given schedule and sends out a email with a link on it. Is there way to only send out the report via email only if there is data on the report? In other words don't send an email to the user if no data is available. Thanks
Question by:7of9121098
1 Comment
LVL 21

Accepted Solution

Alpesh Patel earned 1000 total points
ID: 36564887
First Configure Database Mail from SSRS configuration.

Create Subscription for report and select the data driven subscription.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Introduction Earlier I wrote an article about the new lookup functions (http://www.experts-exchange.com/A_3433.html) that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
In this video I will demonstrate how to set up Nine, which I now consider the best alternative email app to Touchdown.
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

607 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