Any way to have reporting services subscriptions email only when query returns results?

Question

Users are only wanting emails when there are results from a query....is there anyway to get a SSRS subscription to do this?

Answer 1

If you cause the report to fail to render you should be able to cancel the subscription processing - taking that in mind you could run some code embedded in the report that checks to see if data exists and if none does then force the report to fail.

This is all a guess mind you - I have never tried it!