Custom extensions and multiple tables

Is it possible to create a custom extension (DLL) that will push multiple
tables (or datasetes) into SQL report? If not what is a way to push
multiple datasets into report?
Thanksyou can use 1 data set in each data region and have multiple data regions in
a single report..
But if you are talking about having multiple tables in a single data region,
you might try using the SQL UNION statement ie
select name, address, zip from employees
union
select name, address, zip from customers
If the tables are dis-similar you might think of using a join in your
query..
hope this helps.
--
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
"Mark Goldin" <markgoldin@.comcast.net> wrote in message
news:OOmhR2lwEHA.2012@.TK2MSFTNGP15.phx.gbl...
> Is it possible to create a custom extension (DLL) that will push multiple
> tables (or datasetes) into SQL report? If not what is a way to push
> multiple datasets into report?
> Thanks
>|||I guess my question is how to push (not to pull) into RS multiple datasets
using custom extentions.
"Wayne Snyder" wrote:
> you can use 1 data set in each data region and have multiple data regions in
> a single report..
> But if you are talking about having multiple tables in a single data region,
> you might try using the SQL UNION statement ie
> select name, address, zip from employees
> union
> select name, address, zip from customers
> If the tables are dis-similar you might think of using a join in your
> query..
> hope this helps.
> --
> 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
> "Mark Goldin" <markgoldin@.comcast.net> wrote in message
> news:OOmhR2lwEHA.2012@.TK2MSFTNGP15.phx.gbl...
> > Is it possible to create a custom extension (DLL) that will push multiple
> > tables (or datasetes) into SQL report? If not what is a way to push
> > multiple datasets into report?
> >
> > Thanks
> >
> >
>
>