SSRS Report Builder Part 11.2 - Optional Drop Down List Parameters

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:36 Creating the Basic Report 03:39 Creating a Basic Drop Down List Parameter 06:17 Adding an "Any" Option to the Drop Down List 07:41 Checking for the Any Option in a Query 09:05 Allowing Null Values 11:12 Assigning a Default Value of Null 12:22 Displaying the Parameter Label in the Report 14:44 Using Report Parameters and Filters 18:11 Query Parameters vs Report Parameters and Filters 19:26 Creating a Drop Down List of Months 22:06 Making the Month Parameter Optional 24:03 Showing the Month Name in the Report 24:48 Using a Filter for the Month Parameter 27:10 Populating a Drop Down List with a Dataset 30:04 Adding an "Any" Option to a Dataset 33:11 Checking for Null in the Dataset Query 34:04 Sorting the Genre List 37:30 Including the Genre Label in the Report 38:38 Creating a Dataset to List Directors 40:46 Creating the Report Parameter 41:52 Creating the Dataset Filter 44:02 Displaying the Director Name in the Report 44:58 Converting to a Query Parameter 46:28 Using a Query to Populate the Oscar Wins List Learn how to make drop down list parameters optional in SSRS Report Builder. You'll learn how to allow null values for a parameter, how to add this to the list of available values and how to test for nulls in both a query and a dataset filter. You'll also learn how to use UNION queries to add a null option to a dataset and how to use the dataset to populate the available values of the parameter. 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