Stop BI publisher report if no row is returned in data model SQL query
SummaryStop BI publisher report if no row is returned in data model SQL query
I am new to BI Publisher reporting and want to avoid blank report if no rows selected in the query. Please let me know how I can stop.
E.g I am using f/w query:
select target_type,count(*) CNT from mgmt$target where broken_str is not null;
In this, if there is no such target with broken state, a blank report is sent to the confirmed email. I want to avoid this.