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:

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.