Hi,
I have a DB where i am transferering part of the its history table data (events on a table after certain time) to a similar table on a ArchiveDB

Original History table & ArchiveDB one have similar data and Design.

I have a crystal report (CR9) where i need to get information from the 2 tables (from the original history table and from the history on the ArchiveDB)

I need know how to make that my crystal report look for the two tables looking for history as it's possible that for the period of time specified (start date & end date) information is on both tables.

To clarify, let's say that original DB is call MonitorDB and the history DB is call ArchiveDB where i have a store procedure on MonitorDB that is call from my Crystal report.
This store procedure get information from the MonitorDB history table and put it on other MonitorDB table and finally this results and displayed in my Crystal report.

Now i need to my report extract information that could be located on both DB'S history tables in the same report, i mean from MonitorDB history table and from ArchiveDB history table.

So any help or idea is welcome and beforehand Thank you.

Regards,


cphspain

In CR XI you can create 2 datasources and manually link them on a field. With a little playing you should be able to get it to work.