data connection to different source

[unknownly]

Using Cr 10, Oracle 9i
I need to create a report from 2 different datasource.

DS1: Datasource 1
DS2: Datasource 2

I have a pre written SQL which is in use and need to use the sql to build the report.

How can I use the data connection in order to use a command where both the data source are used with the single command

Can we do this?

TIA,
Sweetie

 

[paulmarr]

AS far as I know - this is impossible in Crystal - as you have pointed out - Crystal allows only one data source connection per SQL Command.

You would either accomplish the same thing via sub reports - or somehow temporarily bring the data from one source into a temporary table in the second source - and then create the whole SQL statement from the second source.

I hope this helps.

Cheers
paulmarr

 

[Madawc]

Subreports do do this, as paulmarr says. But also see if you can turn the SQL into two separate Stored Procedures. This can definitely be done in Crystal 10 with different datasets from the same datasource. I'd be interested to know if multiple sources would also work.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10