Home > Archive > Visual Basic Crystal Reports > March 2006 > Multiple DataBase Server Report
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Multiple DataBase Server Report
|
|
| ahmad basheer 2006-03-15, 3:57 am |
| Hi,
I created two ODBC and I want to know how to change between them in
crystal reports???
so basically, i want my application to select fields from the first
Database Server's Table through the first ODBC then select some fields
from the second Database Server's table through a second ODBC (each
ODBC connect to a remote Database server)
Does any one know how ??
| |
| mark gross 2006-03-28, 7:05 pm |
| If at least one of your database servers is SQLserver, establish a linked
server and create a view that returns data from both databases.
"ahmad basheer" <ahmadbsher@gmail.com> wrote in message
news:1142410475.391155.104910@e56g2000cwe.googlegroups.com...
> Hi,
>
> I created two ODBC and I want to know how to change between them in
> crystal reports???
>
> so basically, i want my application to select fields from the first
> Database Server's Table through the first ODBC then select some fields
> from the second Database Server's table through a second ODBC (each
> ODBC connect to a remote Database server)
>
> Does any one know how ??
>
|
|
|
|
|