Shawn Melton (10/17/2014)
I have seen one setup, although is a bit of a hack, is to add code at the end of the procedure that returns the data in the report where it validates the number of records. If no records are being returned you RAISERROR, if the report detects an error it should not send the email. I have never tried this method though.
I like that idea. I might have to try it.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question