CODEWITHSUNDEEP
reporting-services
user2963175
user2963175

Reputation: 81

SSRS Report - Dynamic Connection String and Parameters

I am building a SSRS report portal to run various reports. One of the requirement is to pass the database connection string (server name, database, username and password) dynamically to the report.

Please let me know how to achieve this. I am new to SSRS report.

Thanks Sri

Upvotes: 8

Views: 22010

Answers (2)

Georgy Grigoryev
Georgy Grigoryev

Reputation: 873

You can use parametr and experssion for connection string of datasource

="Data Source=Server;User ID=sa;Password=sa;Initial Catalog="+Parameters!Database.Value

Upvotes: 5

Sam
Sam

Reputation: 7303

You should make sure that your datasource is embedded in the report.

And you can set your Connection string dynamically using an expression.

DataSource Setup

There is some more information on dynamically setting connection strings Here

Upvotes: 8

Related Questions