Home Datapipelines
New Blog Posts: Merging Reports - Part 1 and Part 2

Pulling data from separate databases

edited January 2012 in Datapipelines
I recently archived records for a client to a separate database, "Archive".


Now I realize that one report they relied upon requires both current
records and any records that were archived.

I can't seem to get a report generated that would allow me to merge/join
the current and archived records, or even select each database
separately and print out separate current and archive versions of the
report. If I attempt to utilize the Archive database,
(Design->Data->File->Data Settings->Connection->Database Name) the
dropdown selects it, but, the data is still from the current database.

Any help would be greatly appreciated.

John Turner

Comments

  • edited January 2012
    Hi John,

    Dade (or the built-in data access in RB) is designed to access only one
    database at a time. One option may be to pull the data needed back into
    the original database. Another might be to create some in-memory
    datasets in Delphi and use them to create the report.

    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited January 2012
    Thanks Nico.

    Yes, I thought about creating a query that spans the two databases with
    a join and use that...So, that appears to be the best solution based
    upon your advice.

    Thanks again,

    John
This discussion has been closed.