SSRS Report Builder Part 10.1 - Report Parameters and Filters

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 https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

Chapters
00:00 Topic List
00:35 The Example
02:58 Creating a Basic Table
04:08 Creating a Report Parameter
07:28 Referencing a Parameter in a Filter
09:50 Showing the Parameter Value in a Text Box
12:03 Dealing with No Rows
15:50 Using Date Parameters
20:51 Showing Date Parameters in a Text Box
22:52 Text Parameters and Wildcards
26:47 Concatenating Wildcard Characters
29:08 Formatting Dates in the No Rows Message

This video shows you how to create basic report parameters to filter tables in a report. You'll learn how to create numeric, date and text parameters, including how to use wildcard characters. You'll also see how to display parameter values in the report so that they will be included if the user chooses to export the report results, and how to display a message when the user input doesn't return any results for a table to display.

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