i have to use the dynamic connection string as it was shown in here and i have to get a list of database values if the user selects a particular server name and i tried to use exec sp_databases and in order to populate this data set i need to pass the connection string and the connection string does not have the database name in it so how can i get the list of the database names and give them as available values for the initial catalog parameter. i think you get my point but i really need to get this working. also i am concerned about how are we going to work with reports that share a same datasource. do we have to pass in the satasource for each report individually or is there a way out of that. any help would be apperciated. thanks