Default value for "All records" in a parametered filter

I have a parametered filter in my sql query: Warehouse_Class_Code like '%' + @.Filter + '%'
In the parameter I have several value to set the right filter. When I run the report I always have to select one of the values. I added a label "All records" with a value "&". I tried "%" as a default value at the parameter settings.

In the preview the label "All records" is shown, but when I run the report in the HTML browser, I see <Select a value>. How to change the default value to "All records"?

if you do not need to select one, you can make it non-mandatory and use a query like the following one:

@.ParameterName IS NULL OR
Warehouse_Class_Code like '%' + @.Filter + '%'

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Your code works, but when I want to run the report in the HTML browser I get the message <Select a Value> again. Want I want is to set a default value for all records so I don't have to choose everytime I run the report...