>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.

The solution I'd use would be to build a report cursor using SELECT - SQL, remove the alias from the fields on the report. There are several ways you can actually build the select statement based on the users choices including using a case statement.