Parameter for last name to allow all data at first | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Parameter for last name to allow all data at first

I have a query that uses a parameter for a person’s last name in the where clause. I’d like to figure out how to get the report to pull all names the first time the report is run, then allow the user to specify specific records afterwards. I can’t get the default values right, or I’m missing something else. Thanks!
Got it: check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run! Thanks!
]]>