General information
Category:
Reports & Report designer
Title:
Programatically change which fields show in report
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only