SSRS 2008 Report Model

See more:

SSRS

Hi Friends,

I supposed to create 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)

Question: My requirement is to create Data Source View (DSV) for multiple data sources (basically different databases in the same server). So that the end user can access different databases (in one report model) while creating the report using Report Builder tool. I searched a lot in web. But i did not found any solution yet. I am not sure if it is possible in SSRS 2008. Please let me know the possibility to achieve this requirement.

With Regards,
Anand