Macro substitution doesn't work in reports. You can try EVALUATE() function or dynamicaly build and than run a query that converts any four selected fileds into four predefined names.
>I have a table with 14 fields with the same numeric format. They are named fee1 through fee14. I am creating a report that has four columns for fees. I want the user to be presented a screen that allows them via check boxes or four dropdown boxes to tell which fee columns they want on the report.
>
>I have created a report with four fee columns. How can I change the source of the columns based on the fields that the user has selectd.
>
>I tried establishing 4 memory variables and loading the names of the fields into these variable, and then using & macro subtitution in the fields in the report definition. This gives me a syntax error.
>
>Any suggestions.
--sb--