Hi all.
I have created a Report with a graph also on it.
The users, working through a form only (not the DB window) will want to view that Report run numbers of times against different criteria, probably simultaneously, and probably save it or print it --- so I cannot use the same report but must (I believe create copies of the original)
I created a standard 'template' query and can create other queries based on that, covering the requirements of the users Fine.
The problem is with the Report.
I thought the CreateReport() function created a report based on an existing report (I was going to use all the controls, the graph etc, just repoint them).
Then I found that CreateReport() only creates a blank report and I would have to create all the many controls.
I started to try to instantiate an existing report, etc, but didnt make much much progress.
Does anybody know if it possible for me to view an existing Report, then effectively do a SaveAS (copying it under a new name), and then alter the recordsource etc on that new Report ??