BI Publisher Report in PeopleSoft - Email Report Question
We have a BI Publisher Report that is initialed by an application engine our implementers wrote. With BI Publisher, do these reports email out regardless of succession or error? Is there a way to only send out the email with the report when there is an error? We want the report to only be emailed out when there is an error.
Here's our AE code:
import PSXP_RPTDEFNMANAGER:*;
Local PSXP_RPTDEFNMANAGER:ReportDefn &oRptDefn;
Local Record &rcdQryPrompts, &rcdQryRunParms;
Local SQL &sqlSelectQryParms;
Local number &i;
&oRptDefn = create PSXP_RPTDEFNMANAGER:ReportDefn("EDE_RCV_RPT");
&oRptDefn.Get();
If %OutDestType = 2 Then
&oRptDefn.OutDestination = %FilePath;
End-If;