Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I created a Report Model which will be consumed by the End users to create ad hoc reports using Report builder tool. The Report Model can be created using the Report Model Project in Business Intelligence Studio. It has 3 stages to create the Report Model.

  1. Data Source
  2. Data Source Views(.DSV)
  3. Report Model(.SMDL)

How to create Report Model for multiple data sources so that the end user can access different databases (in one report model) while creating the report using Report Builder tool?

Any possibility to change the datasource of Report Model in RunTime?

share|improve this question

migrated from stackoverflow.com Mar 15 '12 at 12:52

This question came from our site for professional and enthusiast programmers.

1 Answer 1

Depending on the version of Report Builder, you can only build from a single data source. I'm pretty sure this is still the case with SQL Server 2008R2, although Report Builder 3 can consume data directly from a database without needing a report model, although you need to build data sets using the individual connections and I don't think you can group items from different data sets by a common value.

You can do this gouping with SSRS (see this article for an overview), although I can't see an obvious way to do it in RB3. This article indicates that you can't nest items based on different data sets, so it's looking like common rollups aren't possible in RB3.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.