Forum Discussion
Dynamic Connection String SSRS Report
Hello. I am creating a report where I want to have a dynamics connection string for based on a parameter for the Database Name. Error message I am getting is "Format of the initialization ...
if you going to pass the value dynamically, then you need to treat it as an expression. So have an equal at the beginning:
="data source=" & Parameters!server_name.Value & ";initial catalog=" & Parameters!database_name.Value
="data source=" & Parameters!server_name.Value & ";initial catalog=" & Parameters!database_name.Value