You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Conditionally send report to email ONLY if query returns data results

Accepted answer
31
Views
3
Comments
in BI Publisher Learning Center 3 comments

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!