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 string does not conform to specification starting at index 25."
Is the concatenation syntax wrong in the connection string? Can anyone point me in the right direction? Thanks!
1 Reply
- 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
