you're reading...
ACCURATE, Report

Menampilkan Item Dimension di Report Product Result List Detail

Untuk memasukkan Item Dimension yang ada di List | Item | Miscellaneous ke dalam Report Product Result List Detail (seperti di gambar), maka cara yang dilakukan adalah :

001

1. Masuk ke dalam Report |Index To Report | Report Manufacture | Report Product Result List Detail.

2. Kemudian masuk ke dalam Modify | Available columns | checklist di bagian Custom Field yang akan digunakan (misalnya CustomField1 – CustomField5).

3. Masuk ke tab Columns & Filters | Selected Columns & Filters | checklist di bagian Custom Field yang tadi sudah di pilih.

4. Klik tab Designer | Data | First_Query | ganti SQL-nya menjadi :

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

5. Klik tanda checklist

6. 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)

Discussion

Comments are closed.

%d bloggers like this: