Joining Tables Across Multiple Datasets

I am trying to join two tables from two different datasets in SQL
Server 2005 Reporting Services. How would one go about doing this?
Since there are technically two spots to have SQL queries (one for
each dataset), how does one go about doing SQL? Is joining across
multiple datasets even possible? If so, are there clever workarounds?You cannot join datasets in RS. You either need to do this in a stored
procedure OR you should think about subreports. Usually what you need to do
can be accomplished with subreports. For a 1:1 or 1:M relationship
subreports will work for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<rdracer58@.gmail.com> wrote in message
news:1183746250.948449.38960@.o61g2000hsh.googlegroups.com...
>I am trying to join two tables from two different datasets in SQL
> Server 2005 Reporting Services. How would one go about doing this?
> Since there are technically two spots to have SQL queries (one for
> each dataset), how does one go about doing SQL? Is joining across
> multiple datasets even possible? If so, are there clever workarounds?
>sql