locked
Not send email if not exist data RRS feed

  • Question

  • Hello friends

    I have a report that parameter is the date, and this execute every day, somedays this report give back information and other nothing, my question is, how do i make this report when not give back information it don't  sent by email, only send by email when this give back data. This report is configurate to send every day en the sheduler.

    Thank you

    Wednesday, June 28, 2006 12:44 AM

All replies

  • The only way to do this with builtin functions is to make a datadriven subscription (wich is only available in enterprise or developer edition).
    If you don't have the enterprise edition but a bit of time you could make your own delivery-extension wich executes a sql-statement internally and then triggers another subscription if data was found..
    If you are familiar with .net programming this would be about 1day of work.
    Wednesday, June 28, 2006 5:36 AM