Data regions

Greetings,

Can someone explain the rationale as to why nested data regions are restricted to use the same dataset?

Craig

We didn't have time so far to implement hierarchical data source support in our processing engine - but it is under consideration for a future release.

Anyway, there are a few options available today to achieve similar results:
* join the datasets already in the query (e.g. by using linked server functionality)
* use subreports for the "nested data region" - but this is usually not very efficient
* use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source.

-- Robert

|||

hey Robert,

can you point me toward some documentation on how to do this:

"use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source."

Thanks,

jen