Eclipse Community Forums: BIRT » MULTIPLE DATA SETS

Home » Archived » BIRT » MULTIPLE DATA SETS

MULTIPLE DATA SETS [message #120605]

Mon, 30 January 2006 22:18

Eclipse User

Originally posted by: ARASH.BARIRANI.VERIZONWIRELESS.COM

Is it possible to pull in data from a different data source inside one's
select/query call? For example in Oracle:
"create table a as
select a, b, c from table_2@datasource2 "

I guess my quesion would be is there any way to use/access multiple
datasources for creation of a single data set in BIRT.

Thanks in advance.

Arash

Re: MULTIPLE DATA SETS [message #122269 is a reply to message #120605]

Tue, 31 January 2006 19:39

Eclipse User

You cannot create a single data set based on two different data sources in
BIRT 2.0.

However you can use nested query in BIRT to achieve some limited cross data
source joins. I had a earlier post that explains how this works. Check out
my post titled "re: Computed field based on other dataset" posted on
1/24/06.

regards,

--
Gary Xue
Actuate Corporation - Product Development
BIRT Committer

"ARASH " <ARASH.BARIRANI@VERIZONWIRELESS.COM> wrote in message
news:0673b71ba6d30b16ca4d098e8bf621f2$1@www.eclipse.org...
>
> Is it possible to pull in data from a different data source inside one's
> select/query call? For example in Oracle:
> "create table a as
> select a, b, c from table_2@datasource2 "
>
> I guess my quesion would be is there any way to use/access multiple
> datasources for creation of a single data set in BIRT.
>
> Thanks in advance.
>
> Arash
>

Previous Topic:	Blank default value for Report Parameter
Next Topic:	Internal server error

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Sep 16 22:44:59 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter