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.