Conditionally send report to email ONLY if query returns data results
Is it possible to setup a schedule in BI Publisher to run every day that will only output a report to EMAIL if the query fetches at least one row of data?
In other words, if the query does not return any data then I do NOT want to output a report to EMAIL to end users. I only want to output the report to EMAIL if the query fetches at least one row so that I'm not sending out blank reports when I don't need to.
0