You can do this without using Excel by leveraging features in your database. You don't mention what type of database you're connecting to, but in both Oracle and SQL Server (possibly in other DBs as well...) you can set up a "link" from one database to another. Once that's done, you can do one of two things:
1. Create a view in one of the databases that will join the data together in a UNION query.
2. Connect to one of the databases. Then create a command (SQL Select statement) in your report that is a UNION query like this:
Select <fields required in the report>
from Current
where <filter the data>
UNION
Select <fields required in teh report>
from <Archive table through link>
where <filter the data>
The actual syntax for the tables will depend on the database type. In Oracle it would be something like this:
Archive@ArchiveDB
In SQL Server it would be something like this:
dbo.ArchiveDB.Archive
-Dell
IP Logged
