• 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

    --------------------------------