Roadmap › SSRS — SQL Server Reporting Services › Module: Parameters and Interactivity
Lessons in this course (10)
5. Parameters, multi-value and cascading parameters
Intermediate★ Must knowLesson 5 of 10
- Report parameters map to query parameters (
@StartDate). - Data types: Text, Boolean, Date/Time, Integer, Float. Allow null/blank, multi-value, hidden, internal.
- Available values from a dataset (drop-down) and default values (static, expression like
=Today(), or a dataset). - Multi-value: in an embedded SQL query
WHERE RegionId IN (@Regions)works automatically; for a stored procedure, pass=Join(Parameters!Regions.Value, ",")and split it in SQL (STRING_SPLIT). - Cascading parameters — the second parameter's available-values dataset uses the first (Country → State → City). Order matters in the parameter list.
sql
-- dataset for the State parameter (depends on @Country)
SELECT StateId, StateName FROM dbo.States WHERE CountryId = @Country ORDER BY StateName;