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