By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
462,336 Members | 669 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 462,336 IT Pros & Developers. It's quick & easy.

Creating a Report based on another Report

P: 2
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 ??
Sep 27 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

I'ven't been able to understand why do you need to have multi reports with the same structure?

Only coz it's used from many users in the same time??? This wouldn't be a problem...

And the printing also is this is assigned the default printer in each station...

Really I don't see the problem of having one and only one report???

Best regards!

Sep 30 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.