Join tables from different databeses

rbuser

Hi
I use Delphi 7 and RB 10.07.

Is it possible to link two data pipelines from different databases, for
example:
I need report that will list shops and visitors by days, like this
shop1
day 1 visitors 300
day 2 visitors 320
.....
shop2
day 1 visitors 400
day 2 visitors 350
....
shop3
day 1 visitors 360
day 2 visitors 320
....
I have one DB with some dictionaries (DB1) and onother one with some
statistics (DB2).
I created one pipeline on DB1 that list all shops and another one on DB2
that list stats anbout visitors in shops.
Now I tried to link these piplines, but report does not work as desired.
Any help would be appreciated!

Jeka

nicocizik

Hi Jeka,

ReportBuilder does not support linking two datasets from separate databases.
One option that others have used is to create Views that get data from a
separate database and use them in the original DB rather than directly
accessing data from the second DB.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com