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.
- Data Source
- Data Source Views(.DSV)
- 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?