How do I duplicate a report?

  • Thread starter Thread starter Al H.
  • Start date Start date
A

Al H.

Here's the scenario,

I am linking my table to an Excel workbook, sheet 1. I then create a
very simple parameter query to select the records I want and then I created
a report based on the query. I then link to sheet 2 in the same workbook
and create another simple parameter query.

My problem is, how do I "copy" the report layout/format I created with
the first table and query without starting from scratch? Linking the tables
and creating the queries is easy. Setting up the report was very time
conusming/labor intensive. There just has to be a way to take all the work
I did for the first report's layout and use it for the others I need to
create.

Thank you

Al H.
 
Copy the report and give it a different name.
Open the new report in design view & in the proerties box change the Record
Source to your new query (you can do this from the drop down list)
If all your field names are the same you will not have to change anything
else.
If they are different simply select the new field from your field list.
 
Al,

If the names of the fields in the table (columns in the linked sheets)
and controls in the report are the same, the only thing changing is the
sheet, then it's pretty simple:
(a) duplicate the query: do a save as on the original so you can save
under a different name, then switch to SQL view, copy, paste in wordpad,
do a find and replace on the (linked) table name and paste back in the
query SQL view; the query is ready (don't forget to save!).
(b) duplicate the report: do a save as on the original report, then
dispay the report's properties, and on the data tab change the
Recordsource property from the original query to the "cloned" one, save
and you're done!

Alternatively (and more correctly), you can bring together all the data
from all sheets in one table (or a Union query), abse your single report
on it and just filter.

HTH,
Nikos
 
Back
Top