I am creating a stored procedure with a corresponding default value. It is using a default value of 2018 below.
create procedure rpt.FinanceReport @AccountYearParam int = 2018 as select * from FinanceTable where AccountYear = @AccountYearParam
How do I pass the default Value into an SSRS report? So when the user selects nothing for parameter, it will display 2018.
"Using Null values", does not work, since Null will product a nothing. I want the SSRS report to display all values for 2018, if user selects nothing for parameter.