Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2005-12-05 : 13:42:47
|
| 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! |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2005-12-05 : 13:53:37
|
| Got it:check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run!Thanks! |
 |
|
|
|
|
|
Parameter for last name to allow all data at first