Prev: Hyperlink to child report is LOCALHOST when exported to Excel
Next: Security Modifications
From: KarenM on 10 Mar 2010 05:25
Hi All,

I want to define a report with two data sources one is a Hyperion OLAP
source and the other is a SQL Server database. I want the data from
the Hyperion source to pull the corresponding detailed data from the
SQL Server database. Is this possible I can link two data sources and
define one report with data from Hyperion and SQL Server in one
report.

Thanks
Karen
From: Uri Dimant on 10 Mar 2010 06:30
Karen
Yes, you can define two datasets and fill tables or wahever. Can you
elaborate how do you plan to fill the data ?


"KarenM" <karenmiddleol(a)yahoo.com> wrote in message
news:8c224755-769a-461c-b940-105d131fc18d(a)u15g2000prd.googlegroups.com...
> Hi All,
>
> I want to define a report with two data sources one is a Hyperion OLAP
> source and the other is a SQL Server database. I want the data from
> the Hyperion source to pull the corresponding detailed data from the
> SQL Server database. Is this possible I can link two data sources and
> define one report with data from Hyperion and SQL Server in one
> report.
>
> Thanks
> Karen


From: Bruce L-C [MVP] on 10 Mar 2010 12:30
You cannot join dataset in RS. For master-detail reports you need to use sub
reports. That is how Reporting Services handles this.

I do this all the time. I have two data sources and then have a sub report
based on a different data source.

You should also consider using jump to report (sometimes called drill
through). You can easily setup links that allow the user to jump to another
report passing the appropriate parameters.

So, two ways to solve this problem: sub reports and jump to report.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"KarenM" <karenmiddleol(a)yahoo.com> wrote in message
news:8c224755-769a-461c-b940-105d131fc18d(a)u15g2000prd.googlegroups.com...
> Hi All,
>
> I want to define a report with two data sources one is a Hyperion OLAP
> source and the other is a SQL Server database. I want the data from
> the Hyperion source to pull the corresponding detailed data from the
> SQL Server database. Is this possible I can link two data sources and
> define one report with data from Hyperion and SQL Server in one
> report.
>
> Thanks
> Karen

 | 
Pages: 1
Prev: Hyperlink to child report is LOCALHOST when exported to Excel
Next: Security Modifications