[SQL Gurus] How to define a search parameter value

I'm working on a SQL report and am returning a list of values for a column/field, "STATUS", to be used as one of the search parameter.

SELECT DISTINCT STATUS FROM
ORDER BY STATUS

Values returned are [blank], approved, onhold, etc.

How can I get the [blank] value to be set as "All" within the report parameter for STATUS?

Thanks for any help! Much appreciated.

 

I'm using the below statement in the report dataset to return a list of values to be used in a report as a parameter selection for the field Status. The parameter shows a list of available statuses.. the list shows [blank] (blank selection returns all statuses), approved, onhold, and other statuses which are not blank. I need to have the blank selection show as "All" within the report drop down list for the parameter Status.

SELECT DISTINCT STATUS FROM
ORDER BY STATUS

 

thanks Ron, will try this.