Default parameter value to allow all records to show

• sol

  SSCrazy

  Points: 2294

  More actions

  December 5, 2005 at 12:00 pm

  #166431

  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!

• sol

  SSCrazy

  Points: 2294

  More actions

  December 5, 2005 at 12:12 pm

  #607769

  Got it:

  check the allow "Blank Value" box for the parameter, then click "View Report" when the report is run!

  Thanks!