reports from two databases

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
sierralightfoot said:
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.
Click to expand...

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
 
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>
 
sierralightfoot said:
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>
Click to expand...

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
 
Back
Top