reporting services - SSRS Result on Multiple Value Parameters -


i have ssrs report takes multiple valued parameter, when try generate sp's multiple values, desired result on contrary when i'm on ssrs env (test), if select multiple values, top row result, below source;

sp generate multiple rows

select right('0'+storecode,4) + ' - ' + ltrim(rtrim(storename)) result tblinterface_branch storecode in (select * list_to_tbl(@var)) 

function, i've copied tutorial

-- http://www.sommarskog.se/arrays-in-sql-2005.html -- original name: iter$simple_intlist_to_tbl alter function list_to_tbl (@list nvarchar(max)) returns @tbl table (number int not null) begin declare @pos        int,        @nextpos    int,        @valuelen   int   select @pos = 0, @nextpos = 1   while @nextpos > 0 begin   select @nextpos = charindex(',', @list, @pos + 1)   select @valuelen = case when @nextpos > 0                           @nextpos                           else len(@list) + 1                      end - @pos - 1   insert @tbl (number)      values (convert(int, substring(@list, @pos + 1, @valuelen)))   select @pos = @nextpos end return end 

is there i'm missing?


Comments

Popular posts from this blog

SPSS keyboard combination alters encoding -

Add new record to the table by click on the button in Microsoft Access -

javascript - jQuery .height() return 0 when visible but non-0 when hidden -