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
Post a Comment