>SELECT Brk_Name, Brk_Address1, Brk_Address2 , ; && C25 C30 C30 > CtZ_CityName, CtZ_State, CtZ_PostalCode , ; && C25 C2 C10 > Brk_Contact, Brk_SingleMultiple , ; && Memo I4 > Brk_ShippingRate, Brk_ShippingRules , ; && Y8.4 Memo > CtV_DisplayOrder, CSR_DisplayOrder , ; && I4 I4 > CtV_StoreName, CSR_CertificateAmount , ; && C25 Y8.4 > SUM(COr_Amount) AS COr_Amount_SUM , ; && Y8.4 > CSR_Discount, CSR_Percent, CSR_OrgPercent ; && N5.2 N6.2 N6.2 >FROM ST!CertificateOrder ; > JOIN ST!CertificateSizeRate ON COr_CSRFK==CSR_PK ; > JOIN ST!CertificateVoucher ON CSR_CtVFK==CtV_PK ; > JOIN ST!Broker ON CSR_BrkFK==Brk_PK ; > LEFT JOIN ST!CityZip ON Brk_CtZfk==CtZ_PK ; >WHERE COr_OrCFK = '00054' ; >ORDER BY Brk_Name, CtV_DisplayOrder, CSR_DisplayOrder ; >GROUP BY Brk_SingleMultiple, Brk_Name , ; > CtV_DisplayOrder, CSR_DisplayOrder , ; > CtV_StoreName, CSR_CertificateAmount , ; > CSR_Discount, CSR_Percent, CSR_OrgPercent , ; > Brk_Address1, Brk_Address2 , ; > CtZ_CityName ,CtZ_State, CtZ_PostalCode, Brk_ShippingRate ; >INTO CURSOR rc_OrderTabReport>It works as expected without the SUM() and GROUP BY. I've made sure all the non-grouped fields are included and that there are no memo fields in the GROUP BY. Can you see what I've missed?