August 3, 2012 at 1:50 pm
I've got a strange issue, that may be something very simple. I've got a report that runs off stored procedure. Stored procedure has some parameters that are supposed to allow for multiple values.
parameter IN (@parameter)
When I call run the report, it will only return rows if there is one parameter listed, anything more returns nothing. The parameter is set to accept multiple values in SSRS, so I know I covered that. I've looked online, and found a write up, which is supposed to help this by using JOIN in the parameter field
=JOIN(Parameters!parameter.Value, “,”)
I know I'm overlooking something very basic.
August 6, 2012 at 5:05 am
The dataset that is taking the parameter as input, open the dataset properties -> go to parameter -> For the parameter write the expression
=JOIN(Parameter.ParamName.value,",")
If you are using the multivalued parameter in your stored proc, then you can split the value by using the below code in proc itself:
=SPLIT(Parameter.ParamName.value,",")
Is that what you are looking for?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply