My report is tested with desirable outcome and is ready to be scheduled to run monthly. Unfortunately, it choked on this error:

Schedule ID: S14du9skkd01, Job Description: Monthly Receivable report to all Salesrep
Completed with errors/warnings
Task error: ANSI-COMPLIANCE ENFORCED BY CHANGING OUTER JOIN TO INNER
No report to distribute.
  

Despite of the error shown in View Source while running it in MRE, the result came out OK. So I ignored it, but now failed in RC. Is there a way to bypass this error in RC?

(this error is not new to me, I just couldn't get rid of it)

Thanks,

Hua

This message has been edited. Last edited by: Hua,

In the ReportCaster configuration tool, you can specify which errors you would like RC to ignore as warnings only, and RC continues processing instead of stopping.

Darin,

Is this apply to all jobs running in RC once I add the condition to the configuration?

Hua

ANSI-COMPLIANCE ENFORCED BY CHANGING OUTER JOIN TO INNER
  

I wasn't thinking hard enough, my colleague pointed out that one of the join-to file has inner-join at synonym level which giving me this error. In fact, the result was NOT ok when running in MRE. MRE failed me by giving me the results.

Hua

Glad you figured out the problem. As a reference and in answer to your previous question - yes, it does apply to all RC jobs.

Thanks again, Darin.