Email a report ONLY IF it has rows

[Sans]

Hi to all

I've this simple problem:
- we have a report that actually runs on a scheduled basis and sends an email to 6 people eachtime it runs.
- Since the report has filters it could happen that an output with "No Data" is produced
- we'd like to send the email only if the report, when runs, is producing valid rows

How to manage this condition in Event Studio ??

Thanks

[Francis aka khayman]

count rows? does the report have a measure? you can check the total(xx) <> 0

[adam_mc]

Use the burst feature - In that way you won't need Event Studio at all.

If the report has rows, create a burst list of the email recipients.
If the report has no rows, create an empty burst list.

Use the burst list to control the recipients, it will in effect try and send the report to no one if there is no output.
If I remember correctly I believe you will get a warning in the report run history that it tried to send it with an empty burst list.

Hope this helps,
Adam.

[ckapark]

How do you configure it to the count the rows?

I am very new to this product - so detailed instructions would be greatly appreciated!!

Kathleen