multiple server

[versillus]

Can i create report with multiple server.
for example i have two server.
I also create 2 kind of odbc that refers to each server.
How do I managed that 2 odbc to crystal report

 

[synapsevampire]

Just add in the 2nd database. Use Database->Add Database. From there it's dependent upon your version of Crystal, but you'll probably see the next database available under ODBC. The join types will be limited.

You also have the option of a subreport for the second data source, but this would depend on requirements, which your post also didn't share.

Asking technical questions without supplying the version of Crystal and the database will simply net more questions, try posting technical information when requesting it, unless you want a simple yes or no answer.

-k

 

[versillus]

My problem is i use 2 server.. one server is the main server, and the other one is local server in case there is problem with main server.
Now I use report with 2 odbc too , one for main server and the other for local server.
As i know in crystal report if i already set location for odbc main server, i try connect with odbc local server, that report doesn't work with odbc local server.
My question how to set my report so that it can work with two kind odbc with the same table