Скачать или смотреть 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