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
Смотрите видео SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WiseOwlTutorials 12 Март 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9,003 раз и оно понравилось 70 людям.