November 21, 2011 at 11:37 pm
Hi All,
When I select multiple values for a parameter and click view report, its taking only the first value of the parameter. where is the Issue?
Thanks .
November 22, 2011 at 7:42 am
The query you are passing the multiple parameters to has to be set up to use multiple inputs.
At the very least you need something like this in your query.
WHERE YourColumn IN (@MultiValueParameter)
A lot of people, including me, build a function to take multi value inputs and split them properly. You should be able to find some blogs and/or articles on a function to do this.
November 23, 2011 at 6:38 am
Hi,
First use a function, then set this code in your sprocs where clause
where columnname in (SELECT Value from function(@MultiVal,',',1))
Then you need to the input in the main datasets parameters."NOT" from the main meny, in the dataset!
Name @param Value =Join(Parameters!BankID.Value,",")
hope this helps
November 23, 2011 at 11:49 pm
Sorry guys..the issue was mainly with the query that was returning values for parameter.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply