Is it possible to pull information from multiple (separate) databases to create one report from that information? If so, could someone tell me how this is set up?
You can link the tables from the external database to your report database, if you wish.
Just go to File > Get External Data > Link Tables to link the tables to your database. Then you can treat them like regular tables and create queries and reports from them.
