Cancel email for empty report 2

[MariaV]

Hi,
I'm using Seagate Info 7.0.2. In Info Desktop I scheduled one report and the result is send by e-mail. My question is : how can I cancel the e-mail when the report is empty (no data records) ? Right now the user receive an empty page...

Thanks.

 

[BlurredVision]

I don't believe this can be done.. If you ever find away, please let me know! You can create a formula that states no information was available - This is what I do, and it keeps the customer from thinking the report is broken. Brian

http://www.crystalcommunity.com

 

[gsomerville]

You can prevent the email by causing the report to fail when no results are returned - obviously this has the drawback that genuine failures could potentially be overlooked.

For the report to "fail on demand" create a formula which checks a report field for a count of zero or a null return i.e. - the report contains no records or any records it contains are exclued in the report logic. Use a statement which generates a divide by zero error if no records exist.
E.g. <If isnull({field}) or count({field})=0 then 1/0>

 

[MariaV]

Thank you very much. Like you said, this method can hide &quot;real&quot; failures. But from now I'm almost sure that it's my only solution.