SSRS Report Builder Part 11.5 - Multi Value Parameters and Stored Procedures

[@GaymerGaming-40]

Sir you have saved my life, after struggling for 2 weeks this video was the light i needed.

[@WiseOwlTutorials]

Happy to hear that the video helped you Cristian, thanks for watching!

[@alialfaily7829]

thank you after5 day of searching

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@Microgen86]

string.split is new to me. thanks for the imfo👍

[@WiseOwlTutorials]

You're welcome, it's definitely easier than writing a function - although perhaps not as much fun!

[@RohithKK-uh7pp]

Great video sir.

[@WiseOwlTutorials]

Thanks Rohith!

[@miketefera8823]

Your videos are so great. I also practiced your T-SQL questions on your blog. I learn a lot sir! I tried the following simple loop and dump the result into a table other than the function you showed; declare @Stuff_ varchar(20) = '1,2,3,4,5' while len(@Stuff_) > 0 begin select left(@Stuff_, 1) set @Stuff_ = stuff(@Stuff_, 1, charindex(',', @Stuff_+','), '') end

[@WiseOwlTutorials]

Thanks Mike! Happy to hear that you enjoy the videos and thanks for sharing your solution!

[@g.janardhanreddyjanardhan4478]

❤

[@vireshkolagimath4264]

thanks for the video. One question, If I adjust the column width in designer, I am not able to see the data especially text columns. Any idea what is wrong?

[@WiseOwlTutorials]

Hi Viresh! There's a bug in some versions of SSRS which causes text to render incorrectly or not at all. The easiest way to solve it is to format the text in all cells of the table - something simple like changing the font or the font size works. I hope it helps!

[@vireshkolagimath4264]

@@WiseOwlTutorials thank you, it worked.

[@TsiriniainaRakotonirina]

Dear Andrew, I can't state enough how so important is this teaching of yours today. Thank I have question that I can't resolve about it please? ---> What shall I do if I make page break based on the MultiValue Parameters (Action, Adventure ... Comedy) and want each of those Value in a Placeholder on top of each page so that at the beginning of each page, I have ACTION, ADVENTURE ... COMEDY?

[@WiseOwlTutorials]

Hi Tsriniaina! You might find this part of the video on multi value parameters useful kzbin.info/www/bejne/nWeZkoCghdqFbrc I hope it helps!

[@TsiriniainaRakotonirina]

Thank you@@WiseOwlTutorials for your reply. This is exactly what I want, BUT instead of having all the 0,1,2,3,2,4,5 on all the pages, do you know how do I have each value parameter on each page if I apply a page break based on the selected parameters please? I means: Page #1 = 0 Page #2 = 1 Page #3 = 2 (Anythign after the equal is the selected parameter)

[@WiseOwlTutorials]

@@TsiriniainaRakotonirina Hi! I think that you'll find this easier to do using group headers to display the name of the genre rather than trying to link a page number to a selected parameter value. This video shows how to do this kzbin.info/www/bejne/fpPWloCDrbtppKc If it's really important that you do this by referring to the value of the parameter then you can add a text box to the page header with an expression similar to this: =Parameters!GenreID.Label(Globals!OverallPageNumber-1) But this will only work if each of the items you select in the parameter produces exactly one page. I hope that helps!