September 22, 2009 at 10:47 pm
I am having an issue where I need to enter two values into one parameter for a multi value parameter list.
Basically the requirements are:
- I can't modify the stored proc
- I am running a filter using IN against a column (Location) that is returned from the stored proc to only show valid locations, depending on the users selection.
The Location parameter need to look something like....
Label Value
VIC Melbourne, Ballarat
TAS Hobart
NSW Sydney, Southport
etc
Basically the report is running fine when I was using individual locations like: Melbourne, Ballarat, etc but when I group them into states and define the values as being 'Melbourne', 'Ballarat' I am either getting errors or it's not returning anything. And because this is doing all the filtering in SSRS, I can't run a trace to see whats actually being passed in...
Any ideas????
I have tried
'Melbourne', 'Ballarat'
='Melbourne', 'Ballarat'
='JOIN('Melbourne', 'Ballarat')
Thanks in advance,
Ryan
September 22, 2009 at 11:07 pm
Simple question..
Does the sproc support multi-values in the paramter? If not no matter what you want to send it won't work..
Do you know if it allows multi-input? If so you might trace it to see how it is formatted..
CEWII
September 23, 2009 at 1:22 am
The filter has to be within SSRS as I can't modify the stored proc.
I am filtering on the dataset within SSRS with:
Expression: Fields!Location.Value
Operator: In
Value: Parameters!Location.Value
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply