Good afternoon,

Is there a way that a report can be generated from a query/table where the user chooses which fields will be displayed ( other then design view) in the report rather then having many different reports?

Thank You

Jerry

Good afternoon,

Is there a way that a report can be generated from a query/table where the user chooses which fields will be displayed ( other then design view) in the report rather then having many different reports?

Thank You

Jerry
the report wizard does this for you. just follow the instructions in it.

not easy to do this at runtime though, if that is what you mean

the easiest way is just to hide certain columns, which you can do at run time, but its hard to actually change the report layout dynamically at run time