J
Joe
Guest
I run the statement below. However, the result did not display in one row. It automatically puts the result in several rows. It is too difficult to read.
Can someone advise how to put the result in one row? I have same issue when I export the result to a .csv file.
enter image description here
FOR EACH r4_wms.wShipmentDet NO-LOCK,
FIRST r4_wms.wShipment OF r4_wms.wShipmentDet NO-LOCK where wShipment.shipmentNO>5000,
FIRST r4_wms.wOrder OF r4_wms.wShipmentDet NO-LOCK,
FIRST r4_wms.wOrderline OF r4_wms.wShipmentDet NO-LOCK
BY wShipment.ShipmentNo DESC:
Display
wOrder.OrderNo
wOrder.OrderDate
wShipment.ShippedDate
wOrder.CustID
wOrder.sourceDoc
wOrder.srcPO
wShipmentDet.ShipStatus
wShipment.appointmentdate
wShipment.Appointmentno
wOrder.shiptoName
wShipment.carrierID
wShipmentDet.ItemID
worderline.qtyorder
worderline.QtyShipped
wShipment.Volume
wShipment.Weight SKIP
wOrder.Remarks.
END.
Continue reading...
Can someone advise how to put the result in one row? I have same issue when I export the result to a .csv file.
enter image description here
FOR EACH r4_wms.wShipmentDet NO-LOCK,
FIRST r4_wms.wShipment OF r4_wms.wShipmentDet NO-LOCK where wShipment.shipmentNO>5000,
FIRST r4_wms.wOrder OF r4_wms.wShipmentDet NO-LOCK,
FIRST r4_wms.wOrderline OF r4_wms.wShipmentDet NO-LOCK
BY wShipment.ShipmentNo DESC:
Display
wOrder.OrderNo
wOrder.OrderDate
wShipment.ShippedDate
wOrder.CustID
wOrder.sourceDoc
wOrder.srcPO
wShipmentDet.ShipStatus
wShipment.appointmentdate
wShipment.Appointmentno
wOrder.shiptoName
wShipment.carrierID
wShipmentDet.ItemID
worderline.qtyorder
worderline.QtyShipped
wShipment.Volume
wShipment.Weight SKIP
wOrder.Remarks.
END.
Continue reading...