SQL Oracle in 1 data foundation
Posted on 2011-03-09
We have a MS SQL 2005 database that is fed information from an Oracle database. The similar information is customer, invoice number and date. I see how to add both databases to a data foundation. What i need to do is match the information in 1 database to the other based on invoice number. I know i could do this in a subreport, but i want to know how to do this using 2 different data sources in 1 data foundation.
i would like to come into the report with the following columns
invoice1 | invoice date 1 | Invoice amt 1 | invoice2 | invoice date 2 | Invoice amt 2 |
with invoice 1 and 2 being equal unless there is a missing invoice 1 or 2 then i want to see that
Thanks in advance