all groups > sql server reporting services > december 2005 >
You're in the

sql server reporting services

group:

Table detail row with data from multiple datasources


Table detail row with data from multiple datasources PD
12/20/2005 1:49:02 PM
sql server reporting services:
I need to create a table that has column data from one data source (i.e.
olap) and another column on the detail row that has data from another data
source (i.e. sql). Can this be done? Is there a way to 'link' the data from
Re: Table detail row with data from multiple datasources PD
12/20/2005 3:02:02 PM
Thanks. That works well.

[quoted text, click to view]
Re: Table detail row with data from multiple datasources Bruce L-C [MVP]
12/20/2005 4:07:25 PM
I do this all the time (except I am using SQL for both). I have only done
this with a table, not a matrix.

Create a report of the additional data you want. Design it with report
parameters that will pull back what you want. Test it thoroughly. Then drag
and drop the report into an empty field. Right mouse click on the subreport,
parameters, and map the report parameter to the field.

So, I guess the real answer is maybe because I don't know about Olap data
source and if using a matrix I don't know about that. Anyway, gives you
something to try.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button