SQL Server Performance Forum – Threads Archive
Parameter for last name to allow all data at firstI 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!