CODEWITHSUNDEEP
reporting-services
Muhammad Sharjeel Ahsan
Muhammad Sharjeel Ahsan

Reputation: 672

SSRS change Datasource connection String

Can anyone share a SQL Script which simply modify the connection string for a shared datasource in SSRS.

Thanks

Upvotes: 1

Views: 2071

Answers (1)

user359040
user359040

Reputation:

No, because a SQL script can only be run when connected to a SQL data source.

However, I suspect that what you actually need is an expression that can be used for the connection string - something like:

="Data Source=" + Parameters!DBName.Value + ";Initial Catalog=ReportDB"

Upvotes: 1

Related Questions