I am getting this message
(FOC014) THE NUMBER OF ACROSS SORT FIELDS EXCEEDS THE MAXIMUM
when executing the following
TABLE FILE FINAL
SUM CNT1
BY DEPTNAME AS '' NOPRINT
ACROSS VEL1 AS ''
ACROSS PCQTY1 AS ''
ACROSS PERCASES AS ''
ACROSS PEXTENDED_COST AS ''
ACROSS PEXTENDED_SELL AS ''
ACROSS PERSALESCOST AS ''

if i leave off the last across statement it works. I checked the forums and it seems to indicate that I should be able to do this.

if anyone has any ideas help would be appreciated

thanks
Brian

This message has been edited. Last edited by: <Emily McAllister>,

Here is your answer :
FOC Error list

Also notice that even if you are under the maximum number of ACROSS field, you may reach the maximum displayable ACROSS values. Meaning that even if you have only one ACROSS field but you have more than 64 different values (see FOC031 it mention for GRAPH but I think that it's the same max for REPORT), the report won't show up because you will also reach the maximum value.

There is several Max in FOCUS, you can search EXCEED in referred doc to find some.

This message has been edited. Last edited by: MartinY,

I thought this article is pretty useful when you have to go beyond the limits of ACROSS.

https://techsupport.informatio...ver/cof_tcn_m07.html