Joining two reporting services datasets

Hi All,
It is possibile to create a dataset that is a join of two other datasets
(the two datasets are of diverse origin: the first is OLAP the second is
relational)?
Example:
I have dataset 1 and 2 I want to create the third that is a join of the 1
and the 2.
Can anyone help me?
Thank you.if it's just a SQL command you could create a 3rd dataset?
"gdaquila" wrote:
> Hi All,
> It is possibile to create a dataset that is a join of two other datasets
> (the two datasets are of diverse origin: the first is OLAP the second is
> relational)?
> Example:
> I have dataset 1 and 2 I want to create the third that is a join of the 1
> and the 2.
> Can anyone help me?
> Thank you.
>
>|||You can not do this within RS. You either need to have a stored procedure
doing this (can use linked databases) or you need to use subreports.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gdaquila" <gdaquila@.nospam.it> wrote in message
news:2vhku5F2lqt1fU1@.uni-berlin.de...
> Hi All,
> It is possibile to create a dataset that is a join of two other datasets
> (the two datasets are of diverse origin: the first is OLAP the second is
> relational)?
> Example:
> I have dataset 1 and 2 I want to create the third that is a join of the 1
> and the 2.
> Can anyone help me?
> Thank you.
>|||Hi,
Ok,
I will try with a linked server.
You think that I can follow the sample published by microsoft at
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
In this samples I have one regarding the use of linked server.
The last my question is: in this approach, the multidimensional data must be
retrieved via SQL Query not via MDX query it is correct?
Thank you!
G
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
news:eiHEqHDyEHA.3976@.TK2MSFTNGP09.phx.gbl...
> You can not do this within RS. You either need to have a stored procedure
> doing this (can use linked databases) or you need to use subreports.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gdaquila" <gdaquila@.nospam.it> wrote in message
> news:2vhku5F2lqt1fU1@.uni-berlin.de...
>> Hi All,
>> It is possibile to create a dataset that is a join of two other datasets
>> (the two datasets are of diverse origin: the first is OLAP the second is
>> relational)?
>> Example:
>> I have dataset 1 and 2 I want to create the third that is a join of the 1
>> and the 2.
>> Can anyone help me?
>> Thank you.
>>
>|||Sorry, I don't have any experience with MDX queries.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gdaquila" <gdaquila@.nospam.it> wrote in message
news:2vjgbgF2lorcjU1@.uni-berlin.de...
> Hi,
> Ok,
> I will try with a linked server.
> You think that I can follow the sample published by microsoft at
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> In this samples I have one regarding the use of linked server.
> The last my question is: in this approach, the multidimensional data must
be
> retrieved via SQL Query not via MDX query it is correct?
> Thank you!
> G
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> ha scritto nel messaggio
> news:eiHEqHDyEHA.3976@.TK2MSFTNGP09.phx.gbl...
> > You can not do this within RS. You either need to have a stored
procedure
> > doing this (can use linked databases) or you need to use subreports.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "gdaquila" <gdaquila@.nospam.it> wrote in message
> > news:2vhku5F2lqt1fU1@.uni-berlin.de...
> >> Hi All,
> >> It is possibile to create a dataset that is a join of two other
datasets
> >> (the two datasets are of diverse origin: the first is OLAP the second
is
> >> relational)?
> >> Example:
> >> I have dataset 1 and 2 I want to create the third that is a join of the
1
> >> and the 2.
> >> Can anyone help me?
> >> Thank you.
> >>
> >>
> >
> >
>