SSRS Report - Dynamic Connection String and Parameters

Question

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

Sam · Accepted Answer · 2013-11-07 08:18:59Z

8

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

answered Nov 7, 2013 at 8:18

Sam

7,3333 gold badges27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Georgy Grigoryev · Accepted Answer · 2013-11-07 10:00:48Z

5

You can use parametr and experssion for connection string of datasource

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

answered Nov 7, 2013 at 10:00

Georgy Grigoryev

8732 gold badges8 silver badges28 bronze badges

Collectives™ on Stack Overflow

SSRS Report - Dynamic Connection String and Parameters

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related