Connect to multiple servers

rbuser

Hi,

Is it possible to create reports that refer to data from several SQL
servers at once? We have clients with offices in several cities who
would like to write reports that consolidate data from several physical
locations and we wondered if this was possible with Report Builder, or
if it was likely to be possible in the future.

Thanks,

Steve Branley
WCBS

nicocizik

Hi Steve,

From Delphi, this is definitely possible. You can have as many DB
connections and pipelines on a form as needed and the report will access
them as needed.

From DADE, it is also "possible" however not exactly how it was
intended to be used.

For instance, you could place two DB connection objects on a form and a
report. Open the report and go to the data workspace. From there you
could assign the Data Settings to access the first DB connection and
create a query. Then you could re-assign the data settings to access
the second connection and create another query. This would essentially
be accessing two DB's at the same time.

Unfortunately if you ever want to return and edit these dataviews, you
will need to be sure the DataSettings are properly set. Giving them
clever names would make this easier.