SSRS Report Builder Part 11.3 - Multi Value Parameters

By Andrew Gould Full SSRS Report Builder playlist https://youtube.com/playlist?list=PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU 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:04 Creating a Dataset and Table 03:52 Creating a Basic Query Parameter 05:25 Creating a Multi Value Parameter 07:23 Dataset Filters with Multi Value Parameters 10:12 Reverting to a Query Parameter 11:04 Typing in Available Values 13:11 Setting Available Values with a Query 15:19 Setting Default Values 16:19 Displaying Multi Value Parameters in a Label 19:58 Modifying the Label When All Items are Selected 23:11 Creating a Year Parameter 25:05 Returning the List of Available Years 27:05 Calculating the Most Recent Year 30:27 Displaying the Selected Years in a Label 33:01 Creating a Parameter for Genres 36:06 Displaying the Genre List in a Label 38:53 Creating a Parameter and Dataset Filter for Directors 42:47 Creating a Label to Show Selected Directors Learn how to allow multiple values in SSRS Report Builder parameters. You'll learn how to return an array from a parameter and how to test the contents of the array in a query and a dataset filter using the IN operator. You'll also learn how to populate a drop down list using a dataset and how to display the list of selected values in a text box in the report using the Join function. 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