Can any one tell me what is the limitation with Acros column in terms of no of columns and verb objects(WebFocus 5.2.3 on Win 2k) ? I've view another posted Topic about this problem (posted at May 2004, TOPIC: LIMITATION of Across)
I am getting an error (FOC153) VERB OBJECTS TIMES RETRIEVED COLUMNS EXCEEDS MAXIMUM
TABLE FILE EXAMPLE SUM FIELD1 OVER FIELD2 OVER FIELD3 OVER FIELD4 OVER FIELD5 OVER FIELD6 OVER FIELD7 OVER FIELD8 OVER . . . FIELD94 OVER FIELD95 BY FIELDX NOPRINT BY FIELDY NOPRINT BY FIELDZ NOPRINT ACROSS FIELDA AS '' COLUMNS 'JAN' AND 'FEB' AND 'MAR' AND 'APR' AND 'MAY' AND 'JUN' AND 'JUL' AND 'AUG' AND 'SEP' AND 'OCT' AND 'NOV' AND 'DEC' END
It is working fine if I can reduce it to FIELD94.
Any reply would be greatly appreciated.
Thanks, RingoThis message has been edited. Last edited by: <Mabel>,
December 09, 2004, 01:26 AM
Piipster
I found this on the tech support site.
"Reports can now have widths up to 32K. As a result, they can support up to 1024 display objects, depending on the complexity of the specific request."
It seems to me that you have more than that even with FIELD94.