CODEWITHSUNDEEP
sql-serverreporting-servicesssrs-2012
RoverRoll
RoverRoll

Reputation: 135

Multi Value Parameter in SSRS -Values are showing NUll when selected

I tried using Where Location IN(@Location) in my storedprocedure

In SSRS i used =join(Parameters!Location.Value,",")

When i select all values the result is null The value is in string format Eg: 'XXXX,YY','yyy,mm'

Upvotes: 0

Views: 248

Answers (1)

Abhishek
Abhishek

Reputation: 2490

You need to change your Sql stored procedure code so that it could recognize the comma separated values being passed from SSRS.

One way would be using table-value function that can split a comma-delimited string back out into a mini table - link

Once done the code in your stored procedure should be like this - 

WHERE Location IN (SELECT Param FROM dbo.fn_MVParam(@Location,','))

Upvotes: 1

Related Questions