Using different data sources for different configurations in SSRS

I am wondering if SSRS reports can use different data sources depending on which configuration is used? So, for example, if I use the DebugLocal configuration, the reports will use a different database than if I used the Production configuration. thanks Bryan

+4
source share
1 answer

In Report Designer, the easiest way to do this is to edit the shared data source just before running the report.

In the report manager, you can achieve this by having the same data source pointing to different databases in different folders (for example, one folder for DebugLocal, another for Production), as well as deploying and running the report in the corresponding folder.

+2
source

Source: https://habr.com/ru/post/1315785/


All Articles