report from 2 different data source 1

[Durango122]

Hello

I have a report that need information from 2 data source
MS SQL and Oracle
Can crystal report have 2 different data source on the same report
Please give example how it might be done

Regards





Durango122
Remember to used all fingers when waving to policemen

 

[synapsevampire]

Sure, just add both data sources in and then link them as you would any table, however there are limiations such as the join types, and it will prove slow.

You can also link Oracle tables to a SQL Server database.

A common approach is to create an MS Access database and LINK (not import) the tables into there, and create a Access query for use as the Crystal data source.

-k