Multiple datasource for a grid

Hello,
I have a report specification with a simple grid with 4 indicators and an
dimension on rows
Indicator 1,2 and 3 are coming from a cube so i retrive the data with a MDX
query
The last indicator come from a SQL Server (2k5) database in another system.
Today we have a set a reports on the cube and a set of reports on the SQL
darabase.
Can i make this kind of reports with 2 datasources in Reporting services
(2k5)?
Regards,
NicolasMaybe. I haven't done this with a cube but I have done it with relational
data. The concern I have is less where the data is coming from but whether
or not you are using a table control or a matrix to show the data. If a
table control I know it will work.Create a sub report (a sub report is just
a regular report with a parameter you will use to tie the sub report to the
base report). Test the sub report (going agains the SQL data).
Create an extra cell in the row on the table grid. Drag and drop the sub
report onto the cell. Do a right mouse click on the sub report and map the
parameter to the appropriate field.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nicolas Lievain" <n.lievain@.bravosolution.fr> wrote in message
news:OvKBy0efIHA.5348@.TK2MSFTNGP03.phx.gbl...
> Hello,
> I have a report specification with a simple grid with 4 indicators and an
> dimension on rows
> Indicator 1,2 and 3 are coming from a cube so i retrive the data with a
> MDX query
> The last indicator come from a SQL Server (2k5) database in another
> system.
> Today we have a set a reports on the cube and a set of reports on the SQL
> darabase.
> Can i make this kind of reports with 2 datasources in Reporting services
> (2k5)?
> Regards,
> Nicolas
>