How to create dynamic connection string in shared datasource in SSRS report(.rdl)

Question

I have a requirement to create dynamic connection for SSRS reports where the connection information (Server & DB) will be worked out in c# code, so no interaction with end user selecting(Server or DB) Ex. i have one server and multiple databases on that so i need to change connection connection string in shared datasource for ssrs report.

please help me to create SSRS repprt to set dynamic connection string in shared datasouce using asp.net

Ross Bush · Accepted Answer · 2025-05-12 17:28:14Z

0

One way is to pass the database name in as a report parameter. Then on the "Data Source Properties Dialog", click the Connection String's "Expression Button" (fx) and enter something similar to:

="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DatabaseName.Value & "; Trusted_Connection=True;Application Name=xxx;"

answered May 12 at 17:28

Ross Bush

15.2k2 gold badges39 silver badges65 bronze badges

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

Collectives™ on Stack Overflow

How to create dynamic connection string in shared datasource in SSRS report(.rdl)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related