Need Article/Information - 2 databases 1 report

Hi All,

I need to find information on how to get two oracle databases data into one report. The two databases are not really a like, althought they do "talk" to each other and pass data to each other, and their tables are not the same. One is a manufacturing database, the other financial. If anyone can point me in the right direction, that would be great.

I am working with the newer 2005 products.

Thanks in advanced,

Kerrie

Kerrie,

i can't tell you how to collect data from Oracle, but i can tell you how to combine two streams of data. You need to create two reports - one being the main report, the other being a simple one, the simple one then serves as a sub report inside the main report. For instance, if you are showing the data in a table in the main report, then you can embed the subreport in a table cell, and pass values into it as parameters.

Or you can use the existing database link between the two databases (you said they are talking already), and just return all the data in one query. This will make the query slower, but the report will be way easier.

|||

Sluggy,

Thanks for the reply, Thats what I will do!

Thanks again,

Kerrie