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!

By Andrew Gould

https://www.wiseowl.co.uk - Parameters allow your users to filter reports by typing in values or selecting from drop down lists. But what if they want to leave a parameter blank and still see results in the report? This video teaches you how to handle null values in parameters to make this possible. You'll learn how to allow a null value in a parameter and how to write a WHERE clause to handle the null properly. We'll also look at how you can create drop down list parameters which allow null values, including how to append a null value to a dataset, how to mask the null value with descriptive text and how to sort the drop down list to make sure the null appears at the top.

You can download a script to create the database used in this video from the following link:
https://www.wiseowl.co.uk/files/execi...

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Access, Microsoft PowerPoint, Microsoft Word, Microsoft Project, Microsoft Publisher, Microsoft Visio, SQL Server, Reporting Services, Analysis Services, Visual Studio, ASP.NET, VB.NET, C# and more!