SSRS Report Builder Part 11.4 - Multi Value Parameters and Null Values

By Andrew Gould

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.

[TheMisiekMisiek]

Very useful, clear and professional. Continue your tutorials, please. You're my basic source of knowledge on ssrs/ssms.

[moyura]

Thank for sharing, it's easy to follow and very educational. How would you create a filter with few countries in the list e.g. (Select All), Show All Countries, No Country Assigned, US, UK, China ?

[laionegan]

Wonderful videos.the best on ssrs. I am seaeching for a soluzioni where i could create an ssrs query text using the expression.could you post some video on this?i hope to be clear.thx

[nikakalichava]

Hello Mr Owl!

13:00 how do I handle null dates? I have a date parameter but some values are not filled and are null, If I check the null check-box it just gives me all the data (without nulls), but If i type a specific date then I still cant search for data with null dates.

[srinivasbestha]

Hi, How can we create an optional multivalue parameter instead of passing all values by default on a report filter ?

[ericsos]

I have a drop-down list in a parameter and all is one of them so when all is selected no data is displaying.. how can i fix it that issue

[sblack]

This list of available values could be very long, how could we begin typing in the parameter field to filter down the list of available values?

[xxxencryptacion]

Create a Twitter account please as well)

So people can find your content

This is so great you keep producing good stuff !

[Wzxxx]

How to add null to report which uses data from dateveresse data set (DAX query)?