i am trying work on a report with dynamic connection strings in ssrs2005. i was able to generate the list of the databases to use for the initial catalog= Databasename but i would like to know if we can generate the list of the servers using a query so that we can select the list of the servers. also i have a question with the username and password. when i try to give them dynamically it is not working for me. any guess.my main aim is to get the name of the server as available values for the data source = parameters!servername.value