Deployable SSRS DataSource

Viewed 13

Background

I have a suite of SSRS reports which are managed on a dev server (2017).

I keep a copy of the rdl files on a git repo so that they can be cloned directly to a prod environment.

Currently the reports are using a shared datasource.

Important note: the database names and server names will always vary.

The problem

The problem I'm facing is that I am stuck for a way to have a deployable suite, without having have every report edited to correct point to a new datasource on every deployment.

The ideal solution would be to have one datasource that can be cloned with the suite and then amended in that single place.

I have done quite a bit of research and can't see a way to make this is a solution but hoping someone can help me find a solution! TYIA
0 Answers
Related