Hi Everyone, I've come across an issue with one of our Crystal Reports that just won't load no matter what I do. I gave it around 15 minutes and it returned the following error.

 

Is it something to do with the outer joins used????

 

Failed to retrieve data from the database

Details: [Database Vendor Code -564]

Error in File C:\~\Temp\TransactionListing2~.rpt

 

Database type: Informix

Crystal Version: 11

Works in client? No

Works in Crystal Report 11 program? No

Verified Database? Yes, the database is up to date.

Errors found in Formula Editor? No

 

** Start SQL **

 SELECT aualtran.trn_dte, aualtran.src_mdu, aualtran.trn_ref, aualtdes.trn_dsc, aualtran.com_val, aualtran.act_val, aualtran.act_onc, aualtran.act_qty, aualtran.trn_cde, aualtran.cde_n05, auwomast.wor_num, auwotask.tsk_cde, auwodesc.wor_dsc, aualrefn.ref_typ, aualtran.trn_lin, aualtran.trn_num, aualtdes.trn_num, aualtdes.seq_num, ro_wo_mdureso.mdu_dsc, aualrefn.dsc_no1, aualrefn.ref_val, auwodesc.seq_num
 FROM   aualrefn aualrefn, auwodesc auwodesc, auwomast auwomast, auwotask auwotask, aualtref aualtref, aualtran aualtran,  OUTER aualtdes aualtdes,  OUTER ro_wo_mdureso ro_wo_mdureso
 WHERE  (auwodesc.wor_num=auwomast.wor_num) AND (auwomast.wor_num=auwotask.wor_num) AND (aualrefn.ref_val=auwotask.tsk_cde) AND (auwotask.fmt_acc=aualtref.wor_fmt) AND ((aualtref.trn_num=aualtran.trn_num) AND (aualtref.trn_lin=aualtran.trn_lin)) AND ((aualtran.trn_num=aualtdes.trn_num) AND (aualtran.trn_lin=aualtdes.trn_lin)) AND ((aualtran.src_mdu=ro_wo_mdureso.mdu_ref) AND (aualtran.src_acc=ro_wo_mdureso.mdu_acc)) AND aualrefn.ref_typ='tsk_cde' AND (aualtdes.trn_num IS  NULL  OR aualtdes.seq_num=0) AND auwodesc.seq_num=1
 ORDER BY auwomast.wor_num, auwotask.tsk_cde

 

** END SQL