For scheduled reports with an email notification, if there is no data in the exported file, then don't send an email.
For a scheduled report, there is already an option to "Do not export file when no record is found".
However, if you have also configured your scheduled report to send an email notification on completion, the email will still be sent in all circumstances, even if there was no exported file because there was no data.
This issue is particularly noticeable if you have a report that runs daily, but in practice there might only be a few occasions a year where the exported file contains any data. This means there will be possibly hundreds of emails generated each year with no data.
It would be more useful for the recipient user if there was an option for the email to also only be generated if a file with data had been generated to attach to the report. This would make the emails more relevant since they would only appear when action was required.
JamesAllison
shared this idea
AdminJohn Fulton
(Director of Product Management, SmartSimple, Foundant Technologies)
responded
We recommend a default template that includes the record count. We don't feel a configurable option is the best approach. If you agree, please submit another idea with the ask to provide more details on the results in the email so the user knows the report results. In addition, if you are attending the Unite event, we are having a brainstorming session on how to improve the report builder.
