How to choose multiple values for parameter in ssrs2008

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

[="Data Source=servername;Initial Catalog="+Parameters!Database.Value]

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

--[The error has occurred during report processing]

Can some1 help me in this.


more ▼

asked Nov 23, 2011 at 12:33 PM in Default

avatar image

13 2 2 4

Hi Usman,

Can you please explain in detail. Or give in steps.So that I can apply that method.


Nov 24, 2011 at 05:59 AM dev_ritesh

what kind of report you are making? Please give some details.

Nov 24, 2011 at 09:16 PM Usman Butt
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Nov 24, 2011 at 03:23 AM

avatar image

Usman Butt
14.9k 6 13 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 23, 2011 at 12:33 PM

Seen: 892 times

Last Updated: Nov 24, 2011 at 02:00 AM

Copyright 2018 Redgate Software. Privacy Policy