Reporting Services - Working with the same reports accross different databases

Question

I have a Reporting services project that has a number of reports in the the report folder and a Live, Test and Dev data source in the Shared Data Source folder.

I have set up the solution configurations to deploy to different folders on the server based on the config (eg. debug -> dev).

My problem is that i need the reports in the dev folder on the server to use the dev datasource, the test reports to use the test datasource and the live reports to use the live datasource.

What is the best approach to take?

Answer 1

I would recommend that you create a reporting site per environment with the same folder structure and use data sources with the same name in all three places pointing to the appropriate database.

Answer 2

Put the datasources in different folders too.

You can configure the RS project datasource folder as well as for RDLs, so you can keep the same name for the datasource.

Answer 3

Xtraction will provide connection to each data source and ability to allow segregation of user access to these data sources. Xtraction is a self-service, drag-and-drop design and exposes the database fields to the browser interface to allow anyone to create interactive dashboards and reports for export. www.hagridsolutions.com/xtraction