ODBC & server

[versillus]

I have created report with crystal report and it's connect to SQL server using store procedure.
I am using ODBC to connect sql server.
The problem is My office has two server, and it's need two ODBC to connect it.
Can crystal report using two kind of ODBC in the same report with same store procedure too.

 

[synapsevampire]

I don't understand the question

I'll assume that you mean that the same stored procedure exists in both databases.

Crystal can use 2 stored procedures, but a decent database programmer would collect the data across the 2 databases from within a single stored procedure.

Anyway, yes, Crystal can use 2 ODBC connections within one report.

-k

 

[versillus]

synapsevampire,

how can i use 2 odbc connection in one report.
I'm already used link database but the result is not what i expected

 

[synapsevampire]

Well then you know that it works.

What you're asking is based on the data, how it's joined, and many other coefficients/variables.

Nobody can answer this question faithfully without specifics.

You've given no indication of what's being pulled from the databases, nor what you expect the result to look like.

Either flesh out your environment or approach your database programmer to return a single recordset from 1 stored procedure.

-