Menampilkan Item Dimension di Report Product Result List Detail

SELECT
PRODRESULTDET_ITEMNO.ITEMNO COLUMNVALUE_1,
PRODRESULTDET_ITEMNO.ITEMNO PRIMARYKEYVALUE_173,
PRODRESULTDET_ITEMNO.ITEMDESCRIPTION COLUMNVALUE_2,
PRODRESULTDET.QUANTITY COLUMNVALUE_3,
PRODRESULTDET.ID PRIMARYKEYVALUE_30001,
PRODRESULTDET.UNIT COLUMNVALUE_4,
PRODRESULTDET.PORTION COLUMNVALUE_5,
PRODRESULTDET.COST COLUMNVALUE_6,
DATA_COUNT.DATACOUNT COLUMNVALUE_7,
DATA_COUNT.DATACOUNT PRIMARYKEYVALUE_50001,
PRODRESULT.RESULTDATE COLUMNVALUE_8,
PRODRESULT.ID PRIMARYKEYVALUE_10001,
PRODRESULT.RESULTNO COLUMNVALUE_9,
PRODRESULT_WODETID_WOID.WONO COLUMNVALUE_10,
PRODRESULT_WODETID_WOID.ID PRIMARYKEYVALUE_18,
PRODRESULT_WODETID.JOBDESCRIPTION COLUMNVALUE_11,
PRODRESULT_WODETID.ID PRIMARYKEYVALUE_16,
GET_PRODRESULTPORTION.PORTION COLUMNVALUE_12,
GET_PRODRESULTPORTION.ID PRIMARYKEYVALUE_20001,
PRODRESULTDET_ITEMNO.DIMHEIGHT COLUMNVALUE_13,
PRODRESULTDET_ITEMNO.DIMWIDTH COLUMNVALUE_14,
PRODRESULTDET_ITEMNO.DIMDEPTH COLUMNVALUE_15,
PRODRESULTDET_ITEMNO.WEIGHT COLUMNVALUE_16,
PRODRESULTDET_ITEMNO.DELIVERYLEADTIME COLUMNVALUE_17
FROM
PRODRESULT PRODRESULT
LEFT OUTER JOIN GET_PRODRESULTPORTION (PRODRESULT.ID) ON PRODRESULT.ID = GET_PRODRESULTPORTION.ID
LEFT OUTER JOIN PRODRESULTDET ON PRODRESULT.ID = PRODRESULTDET.ID
LEFT OUTER JOIN GET_REPORTCUSTOMFIELD ON 1=1
LEFT OUTER JOIN DATA_COUNT ON 1=1
LEFT OUTER JOIN ITEM PRODRESULTDET_ITEMNO ON PRODRESULTDET.ITEMNO=PRODRESULTDET_ITEMNO.ITEMNO
LEFT OUTER JOIN WODET PRODRESULT_WODETID ON PRODRESULT.WODETID=PRODRESULT_WODETID.ID
LEFT OUTER JOIN WO PRODRESULT_WODETID_WOID ON PRODRESULT_WODETID.WOID=PRODRESULT_WODETID_WOID.ID
WHERE 1=1
AND (PRODRESULT.RESULTDATE BETWEEN :PARAMDATE1 AND :PARAMDATE2)
ORDER BY
PRODRESULT.RESULTDATE ASC,
PRODRESULT.RESULTNO ASC

• Klik tanda checklist
• Tutup dengan klik tanda (x) | ketika mendapatkan konfirmasi apakah akan save report tersebut dalam .fr3 maka klik Yes | save.

Contoh report silahkan di download disini

(Available for V4 & V5)