Thursday, March 29, 2012

Do nto send scheduled report when no data is present

Dear Friends:

Could somebody please help me to stop sending scheduled report when no data is present in the report? Actually I have a daily report which is sent to the client and in a week, two or three days, data will not be there and thus it delivers blank report to the client.

So how can I stop sending blank mails to the client?

Thanks in Advance

Emmanuel Mathew

One possibility would be creating a data-driven subscription with query that returns an empty list of recipients if no data for the report is available.sql

No comments:

Post a Comment