Home › SSRS Report Development
Parameters let users filter reports and let other reports drill through with context. Setting Options Data type Text, Integer, Float, Date/Time, Boolean Available values none (free input), specified list, from a dataset Default values constant, expression (=Today()), or dataset Allow multiple values user can tick several → IN (@Param) in SQL Allow null / blank optional filters Visibility visible, hidden (set by drillthrough/URL), internal Cascading parameters @Country's dataset filters by @Region — SSRS refreshes it automatically when @Region changes. Order matters: dependent parameters must come after the ones they use. Useful expressions Default start date to the first of the month: =DateSerial(Year(Today()), Month(Today()), 1) Show selections in a header…