I am working with RS 2005 and have run into a problem with passing a server and database name as parameters into a server report.
Here's what the connection string looks like in these reports:
="Data Source = " & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DBName.Value
I have default values set for both parameters, so testing usually works fine also. If I run a report with "normal" parameters or no parameters, the report runs fine with the supplied connection string.
The problem occurs when I try to add a parameter to the report that uses a dataset to populate a list of choices. I get the following error when trying to run a report in this situation:
"Error during processing of the ConnectString expression of datasource 'dbConnection'"
I don't get any build errors, just the message above in the report canvas.
Any direction/assistance anyone can provide would be greatly appreciated.. thanks in advance.
Very simple solution, it turns out... just make sure the ServerName and DBName parameters appear above all other parameters in the report definition.