I have created ssrs 2008 report in which i had to create drop down menu for databases .. and what I did is ... just created the parameter(@Database) and changed the connection string of DataSource like
I got the drop down menu for databases (the values i specify in parameter)
This is working fine when I select only one database at a time. But I am getting error when I selected multiple databases. It gives me error
Can some1 help me in this.Thanks
You are doing it the wrong way. You cannot assign multiple Initial Catalogs (Initial DB) in the Connection String. If you are preparing a report for one or more than one databases, then you should consider the master DB (preferably) OR one specific DB as the source. In that database gather all the information based upon your database parameter, and render that output on the report. Cheers.
answered Nov 24 '11 at 03:23 AM