Implementing reusability
When you create reports with one or more developers, there are features available in Reporting Services that can be reused in other places. For example, you can share data sources, datasets, and report parts. Furthermore, when you create queries for your reports, it is interesting to use views, functions, and stored procedures, and reuse them in different reports or projects.
Shared data sources and datasets
Every time you create a report, you can either store the data source reference in the report itself or store it in your project and share it among all the solution reports. You can then publish it separately to the report server. The advantage of this is that all reports use the same reference to the database. So, if you change the reference and point it to another database, all reports are redirected together.
The same is valid for datasets. If you have different reports that use the same datasets, it's better to create the dataset just once, and then share and...
