Is it possible to connect to more than one database in a report? My current report has two subreports that each must connect to a different database. One other possibility that I considered was to create the subreports as seperate reports and then import one of them into the other one. I can't seem to find any information about either of these directions.
Thank you,
Kent
Connecting to more than one database
-
timber0000
- Posts: 7
- Joined: Fri May 20, 2011 7:43 pm
- Location: Manhattan, KS
Connecting to more than one database
You should be able to register more than one Database connection in your report through the Dictionary tab in the designer.
You can add two connections, one for each database.
Then you can add the data sources you need based on the selected connection.
You can add two connections, one for each database.
Then you can add the data sources you need based on the selected connection.