Focal Point
[SOLVED] Getting rid of column names

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7647043196

June 03, 2019, 12:53 PM
ccollier
[SOLVED] Getting rid of column names
I created a table that uses LIST. When using LIST, I can get rid of the column name for COUNTRY by listing country as ' ', but I can't get rid of the column name above the actual list. Is there any way to remove it?

TABLE FILE CAR
LIST COUNTRY AS ' '
END

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


WebFOCUS 8.2.01M on Windows 10
June 03, 2019, 02:08 PM
MartinY
The LIST column is an internal field which you have no control on it.

I suggest the following if you want to add a sequence beside each row (two options from maybe several ways)
TABLE FILE CAR
SUM COMPUTE LISTNO /I2 = LISTNO + 1; AS ''
    COUNTRY AS ''
BY COUNTRY NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
END
-RUN

Or
TABLE FILE CAR
RANKED AS ''
 BY COUNTRY AS ''
ON TABLE SET PAGE-NUM NOLEAD
END
-RUN



WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF
In Focus since 2007