Moving Reports between databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

OldManEd - 23 Jan 2008 01:09 GMT

I have two database files with nearly identical structure but different
data. One has a report that I would like to use in the other one. I know I
will have to make some changes afterwards but I first need to know how to
move this report's structure, not data, from one to the other. Thanks for
help.
EdC

Reply to this Message

Mike Revis - 23 Jan 2008 01:25 GMT

Ed,

Working from the db that you want to bring the report to.
File / import
You are aware, it seems, that you will have to change a few things on the
imported report.

Mike

>I have two database files with nearly identical structure but different
>data. One has a report that I would like to use in the other one. I know I
>will have to make some changes afterwards but I first need to know how to
>move this report's structure, not data, from one to the other. Thanks for
>help.
> EdC

Reply to this Message

Mike Revis - 23 Jan 2008 01:33 GMT

Oops, that might be File / Get External Data / Import.

Reply to this Message

OldManEd - 23 Jan 2008 02:02 GMT

Thanks but have a clarification question. Will this import ONLY the report's
structure?

Ed

> Oops, that might be File / Get External Data / Import.
>
[quoted text clipped - 4 lines]
>>help.
>> EdC

Reply to this Message

fredg - 23 Jan 2008 02:22 GMT

> Thanks but have a clarification question. Will this import ONLY the report's
> structure?
[quoted text clipped - 9 lines]
>>>help.
>>> EdC

Yes, because reports don't have any data, they just show the data from
the tables/queries that are the report's record source.

You can also simply select the report in the main database window.
Copy it. Open the second database, click on Reports, and Paste.
Now you'll have to make sure the record source is correct in the new
database.

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message