Can i use multiple Datasets in a single data region

I want to know that is it possible to show data from more than 1 data
sets in a single data region,
for example i want to show Supplierid,Suppliername and other Supplier
info stored in a table
also i want to show the comapnies names where the Supplier supplies
the material, with the supplier name, which is coming from different
table.
The problem is that these two tables are coming from different
Databases, 1 table is from MS SQL server and the other is from Oracle.
I want to show the data from these 2 data sets in a single table on
the report,
please help1 data region = 1 data set, but you can nest if you need to...and the
nested data region can use a different data set..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Gunjan jain" <gunjan@.nagarro.com> wrote in message
news:f8d018ec.0501170329.1d778388@.posting.google.com...
> I want to know that is it possible to show data from more than 1 data
> sets in a single data region,
> for example i want to show Supplierid,Suppliername and other Supplier
> info stored in a table
> also i want to show the comapnies names where the Supplier supplies
> the material, with the supplier name, which is coming from different
> table.
> The problem is that these two tables are coming from different
> Databases, 1 table is from MS SQL server and the other is from Oracle.
> I want to show the data from these 2 data sets in a single table on
> the report,
> please help|||Can you explain what you mean by nest? I have 1 query from oracle and one
from sql server. I would like to combine the results in one table linking
the queries on building ID. Is this possible?
Thanks,
Melissa
"Wayne Snyder" wrote:
> 1 data region = 1 data set, but you can nest if you need to...and the
> nested data region can use a different data set..
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Gunjan jain" <gunjan@.nagarro.com> wrote in message
> news:f8d018ec.0501170329.1d778388@.posting.google.com...
> > I want to know that is it possible to show data from more than 1 data
> > sets in a single data region,
> > for example i want to show Supplierid,Suppliername and other Supplier
> > info stored in a table
> > also i want to show the comapnies names where the Supplier supplies
> > the material, with the supplier name, which is coming from different
> > table.
> > The problem is that these two tables are coming from different
> > Databases, 1 table is from MS SQL server and the other is from Oracle.
> > I want to show the data from these 2 data sets in a single table on
> > the report,
> > please help
>
>