Can we create report using more than one database?

Anjali · #1 (**permalink**) 03-11-2008, 04:14 AM

Can we create report using more than one database?

vinay kumar · #2 (**permalink**) 04-25-2008, 03:55 PM

yeah..sure its possible ....provided the fields in both the tables of databases should match to each other.. like employeeid or salaryid etc

mmnithyan · #3 (**permalink**) 04-26-2008, 05:57 AM

no at the time only one database we can use
if u use like that u can specify the database name
anyhave ti the time only one.

parthausa · #4 (**permalink**) 07-26-2008, 09:33 PM

yes, we can by using SMART LINK between two tables from two different databases.

SMART LINK is a join , just like JOINs in ORACLE.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode