From the course: SQL Server: Reporting Services
Join today to access over 25,500 courses taught by industry experts.
Report parameter properties - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Report parameter properties
- [Instructor] The parameter that we added to the Inventory by Color report allows you to supply a color, for instance, I'll change this to blue and press the view report button, and that'll update the records that are shown in the report to just that specific color. Now, this is fine if you know what colors exist in the database. If you try and pick a color that doesn't have any matching items, for instance, if I change this to pink, and view the new report, you'll see that I don't get any data back at all. Now, we can improve this interactivity by giving the user a dropdown menu of valid choices, rather than just leave them guessing at what values are present in the database. To fix this up, we need to go back into Report Builder to make some changes to this report. So I'll go back to the homepage of the portal and then I'll click the more info button for the Inventory by Color report and choose to open it in Report Builder. In the report data pane on the left, we can now expand the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.