i have created a report based on a query. i want to keep the design of the report but i want to change the query it gets the data from. could something like that be achieved?
Yes. Assuming that the new query contains all the fields referenced by
the Report. You can either copy the Report Format and paste it with a
new name, then change the data source of the new Report Format or
write code in a single Report's Open Event to allow the user to
specify different data sources.
i have created a report based on a query. i want to keep the design of the report but i want to change the query it gets the data from. could something like that be achieved?
