Hi,

I'm running WebFOCUS 5.2
Here is the report I have:

Column1 Column2 Column3 Column4 Column5 Column6

Here is the report I would like to have:

Column1 Column2 Column3 Column4
Column5 Column6

the problam is this that i am getting the information abt column as a input and the number of column i want to display is not fixed.so i am not able to use over. as i dont know how many column will come as input.i have to consider that when the list of column is going to second page wrap it.

Is there any method for this, can we use over when we have dynamic list of column.

Look at the following as the basis for what

-SET &LINELENGTH=50;
TABLE FILE CAR
PRINT COUNTRY CAR MODEL DEALER_COST RETAIL_COST SEATS
ON TABLE HOLD AS COLS
END
-RUN
CHECK FILE COLS HOLD
-RUN
TABLE FILE HOLD
SUM MAX.FLDNO
ON TABLE SAVE
END
-RUN
-READ SAVE &FLDS.A4.
-RUN
TABLE FILE HOLD
PRINT
COMPUTE COUNTER/I9 = COUNTER +1; NOPRINT
COMPUTE LINELEN/I9 = IF LAST LINELEN + FLEN +2 GE &LINELENGTH THEN FLEN +2 ELSE LAST LINELEN + FLEN +2; NOPRINT
COMPUTE ISOVER/A80 = IF FLDNO EQ &FLDS THEN FIELDNAME | ' AS ' | '''' | ''''
ELSE
IF LAST LINELEN LE LINELEN THEN FIELDNAME | ' AS ' | '''' | ''''
ELSE FIELDNAME | ' AS ' | '''' | '''' | ' OVER';

ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS 'INCFILE'
END
-RUN
TABLE FILE CAR
PRINT
-INCLUDE INCFILE
END

Have you considered using a SUBHEAD ?