I have a table request that looks like this:

TABLE FILE XXX
PRINT
 FLD_1 OVER
 FLD_2 OVER
 FLD_3 OVER
 FLD_4
END

The problem is that the report shows

FLD_1  Value1
FLD_2  Value2
FLD_3  Value3
FLD_4  Value4

Value1, etc comes from the data and is good. However, the text FLD_1, etc. comes from the name of the column OR an AS. I want the text to come from other columns called FLD_1_DESC, etc.

I can not use variables and AS since the first record may have some like: "Source: CAR" As a value and the second record "Source: COUNTRY", etc.

How would I make my text/labels dynamic when I use an OVER?

Fernando

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

What about this?

TABLE FILE XXX
PRINT
FLD_1_DESC AS '' 
FLD_1 AS '' OVER

FLD_2_DESC AS '' 
FLD_2 AS '' OVER

FLD_3_DESC AS '' 
FLD_3 AS ''

END

Thanks Francis.