Joining 2 or more data sources.

I know in crystal I can join 2 different data sources with in the report . Is
this possible in RS ?
(note: by different data sources I mean 2 completely different machines) I
have he columns I can join on just cant find a way to join them . One way was
to bring both parts of the data to a consolidated location. But this is not
the case for some reports .
Any help would be great.
ThanksThe only way to do this is to either do this in a stored procedure or to use
subreports. You can not do a local join between two datasets.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"C.M" <CM@.discussions.microsoft.com> wrote in message
news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
>I know in crystal I can join 2 different data sources with in the report .
>Is
> this possible in RS ?
>
> (note: by different data sources I mean 2 completely different machines) I
> have he columns I can join on just cant find a way to join them . One way
> was
> to bring both parts of the data to a consolidated location. But this is
> not
> the case for some reports .
> Any help would be great.
> Thanks
>|||Do you know if they are going to allow users to join datasets in RS 2005?
"Bruce L-C [MVP]" wrote:
> The only way to do this is to either do this in a stored procedure or to use
> subreports. You can not do a local join between two datasets.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "C.M" <CM@.discussions.microsoft.com> wrote in message
> news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
> >I know in crystal I can join 2 different data sources with in the report .
> >Is
> > this possible in RS ?
> >
> >
> > (note: by different data sources I mean 2 completely different machines) I
> > have he columns I can join on just cant find a way to join them . One way
> > was
> > to bring both parts of the data to a consolidated location. But this is
> > not
> > the case for some reports .
> >
> > Any help would be great.
> >
> > Thanks
> >
>
>|||Not that I have heard.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Clark Kent" <Clark Kent@.discussions.microsoft.com> wrote in message
news:A0BC297B-0DB8-4721-9989-49EF918B7CF5@.microsoft.com...
> Do you know if they are going to allow users to join datasets in RS 2005?
> "Bruce L-C [MVP]" wrote:
>> The only way to do this is to either do this in a stored procedure or to
>> use
>> subreports. You can not do a local join between two datasets.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "C.M" <CM@.discussions.microsoft.com> wrote in message
>> news:9797B692-086F-4325-88B6-5AD0ED038627@.microsoft.com...
>> >I know in crystal I can join 2 different data sources with in the report
>> >.
>> >Is
>> > this possible in RS ?
>> >
>> >
>> > (note: by different data sources I mean 2 completely different
>> > machines) I
>> > have he columns I can join on just cant find a way to join them . One
>> > way
>> > was
>> > to bring both parts of the data to a consolidated location. But this is
>> > not
>> > the case for some reports .
>> >
>> > Any help would be great.
>> >
>> > Thanks
>> >
>>