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