Then yes, only join codes bkic_prod_code to womat_pcode, plus the wopre and wosuf joins you have.
Something like
Code:
SELECT WORKORD.MTWO_WIP_CODE, WOMAT.WOMAT_WOPRE, WOMAT.WOMAT_WOSUF,
WOMAT.WOMAT_PCODE, WOMAT.WOMAT_QTYISSUED, WOMAT.WOMAT_COST,
BKICMSTR.BKIC_PROD_AVGC
FROM BKICMSTR BKICMSTR, WOMAT WOMAT, WORKORD WORKORD
WHERE WOMAT.WOMAT_PCODE = BKICMSTR.BKIC_PROD_CODE
AND WORKORD.MTWO_WIP_WOPRE = WOMAT.WOMAT_WOPRE
AND WORKORD.MTWO_WIP_WOSUF = WOMAT.WOMAT_WOSUF
AND WORKORD.MTWO_WIP_WOPRE=50505
I tried this and it gave me three lines with all of the data needed to do the calculations. It might be quicker to use Excel for reports like this than CR, unless you really need pretty reports.