Duration 24:38
Reporting Services (SSRS) Part 13 - Null Values in Parameters
Published 21 May 2013
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/execise-question-files/qf-898.zip 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!
Category
Show more
Related videos for Reporting Services (SSRS) Part 13 - Null Values in Parameters:
Writing a WHERE Clause in a Query
Adding More Parameters
Modifying the WHERE Clause
Adding Even More Parameters
Dropdown List Params
Datasets for Dropdown Lists
Fiters for Dropdown List Params
Appending a Null Value to The List
Masking the Null Value in the List .. ...Expand 5
" select directorid, directorname, directorname from tbldirector
union
select null, #39; show all' 0'
orderby sortfield
"
adding the query' s output will help viewers understand the last part of this great video =
the query output looks like below. Note, a row of " " simply means a valid data record.
directorid directorname sortfield
null show all directors 0 . . .
4 steven spielberg steven spielberg
48 steven soderbergh steven soderbergh .
thank you so much for preparing and sharing these.
however i have a requirement similar to this, how can we still have a null checkbox as a default value your reply for this is much
am working on a report with 12 parameters. 2 x mandatory start date, end date, 6 x mandatory multi selects and 4 x optional multi selects. My your above tutorial works for dropdown lists that are only single select. How can i achieve the same on multi select drop downs thus making the list optional ( at present i get ' a multi value parameter cannot accept null values'
i have a question in this session. I noticed that we cannot choose the option
" allow how do you handle a dropdown list of directors with null and multiple values?
for this tutorial, specifically that' s the one thing i can' t figure out
with [cte1] as
(
select [directorname]
from [tbldirector]
union select null
)
select
*
, label]all
from [cte1]
order by [directorname]
i am stuck with my report for parameters. I have created multivalue parameter but i would like to give selection to user that they can
i am using sharepoint 2010 and i created a list and i want to do this in it the problem is the query looks very different than this is there a way to do it?
" where fieldname in (@prmmyparam) or @prmmyparam is null"
and select i' m using sql server 2014. Could this be a data source provider issue?