Solved

Report that returns no records.

Posted on 2011-09-19
1
304 Views
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
0
Comment
Question by:7of9121098
1 Comment
 
LVL 21

Accepted Solution

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

Create Subscription for report and select the data driven subscription.
0

Featured Post

How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

Question has a verified solution.

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

Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

808 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