From the course: SQL Server: Reporting Services
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Report parameter properties - SQL Server Tutorial
From the course: SQL Server: Reporting Services
Report parameter properties
- [Instructor] The parameter that we added in the inventory by color report currently allows you to supply a color. For instance, if I type in blue here and press enter, the report will update to show me all the blue products. This is fine if you know what colors exist in the database. If you try a color that doesn't have any matching items, for instance if I type in pink here, the report updates and doesn't show us anything. We can improve this in our activity by giving the user a drop-down menu of valid choices rather than leaving them guessing at what values are present in the database. To fix this up, we'll switch back into design view. We can now expand the parameters folder to see all the different parameters that are saved in the report. It's worth noting that you can include several parameters in a report, which might be helpful for very large, complex data sets. In this report, though, we just have the one called color name. When you double-click on the parameter, it'll bring…
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.