Hi Team, Using the reports module we have scheduled number of reports for the client. e.g. orphan accounts, terminations etc. The client don't want to receive the email if there are no records in the report. How can we achieve this from the reporting module?
You can create a custom workflow with some sql logic that checks if there are records, if there are any you can send trigger the report from the workflow so it get's send to the user.
I guess Tim's solution will be the only possible way. There isn't a setting as far as I know from reports that will not send if it is empty.
You can create a custom workflow with some sql logic that checks if there are records, if there are any you can send trigger the report from the workflow so it get's send to the user.