Merge datas from different DBs in one report?

Hi,
How can I show datas in one report, fetched from more than 1 DB?
thanks,
JensMake 2 datasets and display data in 2 table or matrix components.
Jens Brenner wrote:
> Hi,
> How can I show datas in one report, fetched from more than 1 DB?
> thanks,
> Jens|||<ijeremicyu@.gmail.com> schrieb im Newsbeitrag
news:1184056641.144866.93480@.w3g2000hsg.googlegroups.com...
> Make 2 datasets and display data in 2 table or matrix components.
Can 1 matrix show 2 datasets? Or must I use 2 matrix?
Jens|||<ijeremicyu@.gmail.com> schrieb im Newsbeitrag
news:1184056641.144866.93480@.w3g2000hsg.googlegroups.com...
> Make 2 datasets and display data in 2 table or matrix components.
Can 1 matrix show 2 datasets? Or must I use 2 matrix?
Or can I make a 'select' on a dataset?
like:
select col from $dataset1
union
select col from $dataset2
Jens|||1 dataset - 1 matrix
1 dataset - 1 table
You can't combine data from 2 datasets.
\Jens Brenner wrote:
> <ijeremicyu@.gmail.com> schrieb im Newsbeitrag
> news:1184056641.144866.93480@.w3g2000hsg.googlegroups.com...
> > Make 2 datasets and display data in 2 table or matrix components.
> Can 1 matrix show 2 datasets? Or must I use 2 matrix?
> Or can I make a 'select' on a dataset?
> like:
> select col from $dataset1
> union
> select col from $dataset2
>
>
> Jenssql