Dynamic shared datasource

hi ,

In that case your connection string will be dynamic if you want to connect to multiple Sql server databases on different server .

lets say your report will first run using ;

Data Source=local;Initial Catalog=AdventureWorksDW2012

and second time when you need to run this report on different server then for same report your connection string will be

Data Source=local2;Initial Catalog=AdventureWorksDW2012

In that case you can use expression-based connection string.

follow below link

http://ift.tt/1s8Rxac

Please share if you have any doubts.

Thanks