Menampilkan Item Dimension di Report Product Result List Detail

Untuk menampilkan Item Dimension di Report Product Result List Datail yang ada di List | Item | Miscellaneous ke dalam Report Product Result List Detail, seperti gambar dibawah ini:list dimension persediaan

Berikut adalah langkah-langkahnya:

  • Masuk ke dalam Report | Index To Report | Report Manufacture | Report Product Result List Detail.
  • Kemudian masuk ke dalam Modify | Available columns | Checklist di bagian Custom Field yang akan digunakan (misalnya CustomField1 – Customfield5)
  • Masuk ke tab Columns & Filters | Selected Columns & Filter | checklist di bagian Custom Field yang tadi sudah di pilih.
  • 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
  • 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)

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *