Connect ODBC

[171171]

hai all,

I want change the report from ODBC to other ODBC.
Exampe :
I have one Report but I want connect to 2 ODBC
Report Sales --> ODBC A to Database ERP1 in SQL Server
same Report I want to ODBC B to Database ERP2 in SQL too
Please Help How can i do in Report Sales if the automatic change ODBC but I wan't design report from Crystal Report Designer .
Please Help

 

[pgtek]

hi
you can go to database set location in crystal report designer and re point to the new odbc connection.
cheer

pgtek

 

[171171]

Hai, how with other report ?
Because the report count 50-60 report .
I want otomatic but not design . How connect 1 one report with 2 ODBC ?

Thank's

 

[pgtek]

Hi

if i understand correctly you have 1 report only but want to run the same report on 2 diferent odbc connection?

pgtek

 

[171171]

yes, I want the run 1 Report with the 2 ODBC .
That's Right .

Please help. because if change in database location is not posible because my report is 50-60 reports.

Thank's

 

[pgtek]

Hi
well i think you might have to create 2 report for i don't think crystal allows this.
Or try creating a sub report of the first on but get that sub report to connect to the other odbc

cheers

pgtek