Querying two databases

[RichyTT]

HI,

I'm hoping to use Crystal 8.5 to query two separate sql server databases. The structure, table and field names are common, but they are located on different sites. We have the infrastructre in place to communicate, but I have concerns about distingushing between databases whilst deep in authoring!

I believe I can utilise aliases to distinguish tables, but i have concerns about the ODBC connection, datatransfer rates and any nasty suprises that lay ahead!

Any experience you may have would be gratefully received.

Brgds

 

[dgillz]

This is very doable. Just create 2 ODBC data sources and write the report. I have done this many times with no big gotchas.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

You also might consider a Stored Procedure to obtain the data.

When using different data sources Crystal will limit the join types, that's one gotcha, the other is that Crystal must then act as a database, and it's slow.

-k