ankurk2 (11/23/2011)
Anyone got it working with multiple values of parameter? I get this error:"Error during processing of the ConnectString expression of datasource ‘xxx’."
conn string: ="Data Source=206.17.24.23;Initial Catalog="+Parameters!CountryName.Value
For single value its working fine but foe multiple values its not working.
Any hint would be greatly appreciated!
Ankur
Ankur,
you may use the following string for creating conneciton string
="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=" & Parameters!DBName.Value
we use Windows Authentication to connect , so the first parameter is for servername and second for databasename
this works.
Jeswanth
--------------------------------