I need to attach two tables from two different data sources--an Oracle DB I have no control over, and an Access DB that I do. Here are the fields in each:
Oracle
Order #, Line #, Sell, Cost
Access
Order #, Line #, AdjSell, AdjCost
and I need to link the two so I can create a report with the line:
Order #, Line #, Sell, AdjSell, Cost, AdjCost
Seemed like a no brainer. I just linked the two together by Order# and Line#. Then I found out that while the combo of Order# & Line# makes the records unique in my table, it's not the case in the Oracle DB. That DB routinely has situations like this:
Order #, Line #, Sell, Cost
17789, 001, $100, 0
17789, 001, $0, $75
So I need the summary of those two:
17789, 001, $100, $75
to attach to my single line so I can add AdjSell and AdjCost to the end of it.
I could create an Access query to summarize the Oracle table and then report off of that, but it slows down the report in a big way. I was just wondering if there is a way to handle that kind of join in Crystal without doing the Access Query.
Hope that made sense. Thanks!
|