sql server reporting services: Joining Tables Across Multiple Datasets -- sql server reporting services

Joining Tables Across Multiple Datasets

rdracer58 NO[at]SPAM gmail.com
7/6/2007 11:24:10 AM

sql server reporting services: 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?

Re: Joining Tables Across Multiple Datasets

Bruce L-C [MVP]
7/6/2007 2:58:25 PM

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

[quoted text, click to view]