reports from two databases

[Guest]

I have one report from each of two databases. I want to use one database
report as a subreport for the other. The common/masterfield/childfield would
be "city." Can I do this?

I do not want to link/merge/unite/etc the databases then do the report.

 

[Larry Linson]

I have one report from each of two databases. I want
to use one database report as a subreport for the other.
The common/masterfield/childfield would
be "city." Can I do this?

I do not want to link/merge/unite/etc the databases then do the report.

Two separate _databases_ or two separate _tables_?

If you come from a dBase or other non-Access background, the terms are
sometimes used interchangeably, but they aren't the same in Access. You can
execute a Report in another Access database by using COM automation, but you
can't embed a Report from another Access database in a Subreport Control,
AFAIK.

Two tables, with a relationship and common Field, should present no problem
in doing what you want.

Larry Linson
Microsoft Access MVP

 

[Guest]

Yes, two separate databases, not tables. Each reports has three subreports.
So am I going to be able to take these report and put them together. Tell me
more about Com automation>

 

[Larry Linson]

Yes, two separate databases, not tables. Each reports has three subreports.
So am I going to be able to take these report and put them together. Tell me
more about Com automation>

COM automation is the "Component Object Model" mechanism for executing an
automation-enabled program via using its object model from another program.
It's far too extensive a subject for a newsgroup post. (Google is your
friend.)

But, with or without it, you can't place a Report from another Database into
a Subreport Control on a Report.

Larry Linson
Microsoft Access MVP