Thanks Asim and Karthikeyan, I am not asking how to set multiple values. I am saying for that connection string I am not able to use multiple value as it takes only one value at a time. If you have any other method so let me know. Thanks

I already asked about 2008 ssrs drop down menu for databases .. and what I did is ... just created the parameter(@Database) and changed the connection string like [="Data Source=servername;Initial Catalog="+Parameters!Database.Value]... This is working fine when I select only one database at a time. But I am getting problem when I selected multiple databases. It gives me error. [The error has occurred during report processing] Can some1 help me in this. Thanks

Hi Lola, I know this. That's why I asked here what should I do. If you have solution for this please let me know. Thanks

Hi, Are you talking about connecting to multiple databases using single connection string? if this is so, i don't think it is possible. Well, for getting values of multiple selection you can use =Join(Parameters!Database.value, ",") Change comma with whatever you want. Regards.Regards,<o:p></o:p> Asim Bagwan<o:p></o:p> Kindly mark the replies as Answers if they help!

Hi Asim Thanks for reply. I explained you what I did. The parameter(@Database) I created, I used option 'specify values' and put all three of my databases and there values. Now please tell me what should I do so that I can select multiple values too. Do I have to change connection string or something to do with parameter value. Thanks

Hi, To allow multiple values go to parameter properties -> General Tab -> Check Allow Multiple Values option. Regards.Regards, Asim Bagwan Kindly mark the replies as Answers if they help!

Hi aka_ankur, Generally, it is designed to have only one database refered in "Data Source=servername;Initial Catalog=" connection string. This is to say, we cannot use a multi-value parameter in the connection string. Thanks for unerstanding. LolaPlease remember to mark the replies as answers if they help.

Hi , Check this article on the Multi value parameters, hope this will be helpful for you http://beyondrelational.com/blogs/sherryli/archive/2010/03/12/using-multi-value-parameters-in-ssrs-report.aspxThanks Karthikeyan Anbarasan www.f5debug.net Free Ebook on SSIS Tutorial - Download here SSIS Step by Step