Macro substitution on a report

[roselover]

I have a table in which the field names will be variable. I need to make a report off this table. On the page header, I can successfully create the title for the column by making a label referencing field(3).

However, in the detail of the report I need the contents of field(3) to show, not the name. I've tried &field(3), but it doesn't like the syntax.

Does anyone know how I can accomplish this?

Thanks

 

[bborissov]

EVALUATE(Field(3))

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[roselover]

That's wonderful! Thank you so much for the quick response!