CODEWITHSUNDEEP
sqlsql-serverreporting-services
CeejeeB
CeejeeB

Reputation: 3114

Reporting Services - Working with the same reports across different databases

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?

Upvotes: 2

Views: 491

Answers (2)

gbn
gbn

Reputation: 432210

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.

Upvotes: 4

Raj More
Raj More

Reputation: 48016

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.

Upvotes: 1

Related Questions