sql server reporting services: Can you JOIN a DataSet? -- sql server reporting services

Can you JOIN a DataSet?

jerrynixon NO[at]SPAM gmail.com
10/12/2004 2:50:26 PM

sql server reporting services:

My report has two DataSets.

The first has two columns EmployeeId, EmployeeName
The second has two columns EmployeeId, EmployeeEmail

Doing a JOIN in the SQL is not a possibility.

I want the following output table:

EmployeeId EmployeeName EmployeeEmail
------------------------------------------
123 Jerry jerry@email.com
234 Jonny jonny@email.com
345 Jenny jenny@email.com

How do I accomplish this?

Re: Can you JOIN a DataSet?

Bruce Johnson [MSFT]
10/13/2004 10:04:13 AM

SQL Server 2000 Reporting Services only supports one dataset pre data region
unless the other data regions references are aggregated
(=First("Field!<Fieldname>.Value, "<DataRegionName>")>.

Several possible alternate approaches might be to
* Do the join in your query and use a single data set
* Use a view as the basis for the dataset
* Use openrowset
* Use unions
* Use linked servers

--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]