Sorry, don't know how I missed those.

wasn't this the group by in your original post ?

GROUP BY Brk_SingleMultiple, Brk_Name				, ;
	CtV_DisplayOrder, CSR_DisplayOrder			, ;
	CtV_StoreName, CSR_CertificateAmount			, ;
	CSR_BrokerDiscount, CSR_FamilyPercent, CSR_OrgPercent	, ;
	Brk_Address1, Brk_Address2				, ;
	CtZ_CityName ,CtZ_State, CtZ_PostalCode, Brk_ShippingRate ;

The memo field is not allowed in the group by but is also not allowed in the result set. (this one bit me recently as well ) It would be meaningless in any case, unless it is the same for every record.


>>All the non-aggregate fields have to be included in the group by
>>
>>Just for openers, I don't see CSR_\Discount ( Is that backslash a typo?) or CSR_Percent. ( there are probably more )
>
>Yes, the backslash was a typo (posting late evening was probably a misteak) - it's corrected in the quote below. I'm quite sure that ALL the non-aggregate fields have been included in the GROUP BY with the exception of memo fields which are not allowed, according to the help.
>
>
>>>The honor of your assistance is requested. I've spent too many hours looking at this SQL-select statement trying to figure out why "The GROUP BY clause is missing or invalid". In the first part, I've added the field type/size at the end of the line. This is generating a cursor for a report.
>>>

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?