SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values
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:30 Creating the Basic Report
04:14 Creating a Multi Value Parameter
06:45 Attempting to Allow Null Values
08:45 Substituting Nulls
10:04 Allowing Blank Values in Report Parameters
11:23 Typing a List of Available Values
13:22 Populating Available Values with a Query
17:30 Setting Parameter Default Values
18:09 Creating a Multi Value Parameter for Years
20:29 Identifying a Substitute Value for Null Years
22:58 Populating the Year List with a Dataset
26:42 Showing Films with a Null Country
30:58 Creating a Multi Value Parameter for Countries
32:30 Substituting Null Country ID Values
34:07 Creating a Dataset to Populate the Country List
36:34 Sorting the List Items
Learn how to handle Null values in your multi value parameters by substituting Nulls with a replacement value in your Available Values lists. You'll also learn how to test for the substituted values by using the ISNULL function in your dataset queries.
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
Watch video SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 12 March 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9,003 once and liked it 70 people.