I am getting an error
(FOC153) VERB OBJECTS TIMES RETRIEVED COLUMNS EXCEEDS MAXIMUM
Is there a simple way to convert the following syntax
TABLE FILE EXAMPLE
SUM
FIELD1 OVER
FIELD2 OVER
FIELD3 OVER
FIELD4 OVER
FIELD5 OVER
FIELD6 OVER
FIELD7 OVER
FIELD8 OVER
.
.
.
FIELD111 OVER
FIELD112
ACROSS FIELDX
END

to
TABLE FILE EXAMPLE
SUM
FIELD1
BY FIELD2
ACROSS FIELDX
END

Any reply would be greatly appreciated.

Thanks,
kj

Forgot to mention, I am on WF 5.3.2 on Win2k.

Other than the possiblity you've exceeded a maximum, I recall from my 'old mainframe focus days' that message occuring when the column headings/labels were to many. I had an issue in WebFOCUS similarly on the 5.3.4 version we're on where I had to label my colums 'a' 'b' 'c' and so on. Seemed to work better under 7.1.x

Hi kj,

I ran some search on Information Builders' online documents and came across the following topics which may be of interest (also many thanks to Leah's input, which helped me in searching ):

Limit of Display Fields in TABLE request
http://techsupport.informationbuilders.com/sps/71721027.html

FOC153 and FOC031 when using ROW-TOTAL
http://techsupport.informationbuilders.com/sps/80671001.html

Hope this helps.

Cheers,

Kerry

Thanks for your reply. I found this MacGyver technique in the tech serach very helpful.
http://techsupport.informationbuilders.com/bestpractice...ver/cof_tcn_m07.html