More than one datasource

[PhilMyWallet]

I have 2 seperate database which are identical except for the location. I need to import the data into the Crystal as though they are one source.

E.G.
'Town 1 Datasource' contains - Name / Sales info
'Town 2 Datasource' contains - Name / Sales info

I would like to produce a single report which shows overall names / sales info.

Is this possible?

 

[TheBlondOne]

It should be possible. Depending on how the 2 tables are you should be able to either link the tables together using a relevant linking field or you could include the info from the second table in a subreport and then insert that into the main report.

HTH

Steve

 

[Turkbear]

Hi,
Use a Command Object to create a UNION of the 2 sources and use that Command as the source of your report.

With more info on what database you are using, a more detailed answer can be provided..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[PhilMyWallet]

I have tried to create a UNION, however both databases / tables have the same names, so I think this will cause conflicts. If I could create a UNION inside CR, that would be fine as I could use an alias inside CR.

Thoughts???

 

[Turkbear]

Hi,
That is why I asked about what database...The method/code will vary, depending on that.. With Oracle, for instance, they can have the same name since they will be in different instances:
Select * from table1@local
UNION ALL
Select * from table@remote






To Paraphrase:"The Help you get is proportional to the Help you give.."