By Andrew Gould
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link [ Ссылка ] to make a donation. Thanks for watching!
Chapters
00:00 Topic List
00:31 Creating the Data Source and Dataset
02:31 Creating a Table
03:22 Creating a Query Parameter
04:42 Making a Parameter Optional
06:44 Altering the Where Clause
08:48 Adding Numeric Parameters
11:51 Optional Date Parameters
This video shows you how to create optoinal query parameters in SSRS Report Builder reports. You'll learn how to add parameters to a query and how to allow null values for those parameters to make them optional. You'll also see how to alter the Where clause of the query to check if the parameter value is null and ignore it if so.
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
