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

By Andrew Gould Full SSRS Report Builder playlist    • SSRS Report Builder   If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching! Chapters 00:00 Topic List 00:38 Creating a Data Source 02:13 Creating a Dataset and Basic Report 03:59 Creating a Basic Multi Value Parameter 05:36 Setting the Available Values of a Parameter 07:11 Creating a Stored Procedure 10:25 Using a Stored Procedure to Populate a Dataset 11:40 Using the SQL Server Profiler 15:25 Changing the Data Type of the Parameter 18:27 Using the String_Split Function 22:27 Updating the Stored Procedure 24:28 Creating a Table Valued Function 27:53 Declaring Variables in SQL 29:18 Creating a While Loop 30:54 Inserting Values into a Table Variable 32:40 Returning a Substring 34:28 Finishing the Loop 36:20 Creating and Testing the Function 37:57 Using the Function in a Stored Procedure 39:01 Adding More Parameters to the Stored Procedure 41:08 Setting Available Values for Countries 42:15 Restricting the List of Countries Learn how to successfully pass multi value parameters to a stored procedure in SSRS Report Builder. You'll see how to use the SQL Server Profiler to observe the values passed into a stored procedure to understand why the basic technique doesn't work. You'll learn how to use the String_Split function in SQL to split a comma-separated string into a table of values. For users of earlier versions of SQL Server you'll also learn how to create your own table-valued function to split a string. Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more